Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have shared an excel file, where I have shared the screenshot of the type of chart I want to show and the sample data to build it. Kindly help me with it.
Thanks,
Kharansu
Hi @prasad333
Yes, it is possible by following the logic described by the solution in this topic: Dynamically choosing dimensions for graphs / tables ; the author of this solution selects the required dimension from a table listing the name of the columns on the table shown in the bar-chart.
Extending this logic to your particular problem, you need to "add" 3 columns, like [2019], [2020] and [2021] in your load script, and provide a Target_Years table with the values, 2019, 2020 and 2021 (which correspond with the 3 new columns).
The magic is completed in your bar-chart by using the following expression for its dimension field:
=$(=MinString(Target_Year))
I am attaching a demo solution for your problem, the only issue I could not address was sorting the year data chronologically, it refuse to include the expanded year in the sequence of years, as it is always appearing at the end.
hth