Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello.
I don't know if is this a bug or there is something that I can't see.
I use the same measure in two differents components in the Power BI Desktop, a table and a Waterfall Chart:
The total is different for the two components, but the partial data are the same. There are the same filters/interactions for all the components in the page.
Do you know what could be happening?
Many thanks in advance.
Solved! Go to Solution.
I have a short post on this topic, perhaps it will help you get through it:
Well, for the table component, it looks like you are 153710.05 off (lower). It's all about context. The waterfall chart has the correct total by my calculation. The important thing to remember about the table visualization is that with measures, it is not simply totaling the individual components but rather re-evaluating the measure in the context of all rows. I do not believe that is how the waterfall chart works because of the type of visual display it renders, that wouldn't make sense. So, if you have some negative numbers in your data, your table visualization would account for those and possibly throw off your numbers whereas with the waterfall chart it would not? Can't be certain without the raw data.
Hello,
Thank you for your time.
That's right because a label with the measure has the same value as the table. But I have another measure that works in reverse mode. The total (label too) is bigger for the table than the waterfall chart. Querying the data in the source database with the filters that affects context (only year and proyection), both cases the right values are shown in the waterfall chart component:
Thanks.
I have a short post on this topic, perhaps it will help you get through it:
Thanks a lot, this is just my case.
Awesome, glad that helps!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |