Forum Discussion
Running Total with categories
Anonymous
With the current data your have, it is not possible to achieve your expected bar chart. The chart does not show data for other [Geo] (e.g.year 2020, 2023) is because you have no data to record the power of Year 2020 for [Geo] other than Americas, so you can not use the Year column show the value of that year.
To make it clear, I create a pibx with 3 additional rows for each Geo of year 2020. (no value).
In my opinion, a line chart is more appropriate to see the trend with your current data. Or you can just edit your original data by adding rows to fill the blanks for years with no value like the 3 rows I added in the pbix.
Paul Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous thank you very much for your input and for letting me understand the limits of the visuals.
Line charts can be a solution even though the still keep some limitations.
I was just wondering if there is a way to automatically create a new table with Years as rows and Geo as columns summing up the values of the previous table without any particular input but just with DAX code. This way it should work and also the limit of the line chart (values are "interrupted" at a specific year if there is no further input for that Geo for a following year) can be overcome.
Can you help on this please - if it is feasible?
Many thanks in advance!
Anonymous sorry to bother you on this, but do you see a way to proceed as described in my previous message?
Many thanks!