Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a measure called total orders and i used ALL function to keep this measure not change with order dates filter and it is worked...
But my problem is that i have a bar chart in x line is order date and y line is another measure about counting people who ordered..
when i press any year of the chart the measure number that i want to keep it not changing is changing here with this bar chart!
What is the problem !!
Hi,
Share some data to work with and show the expected result.
Hi @Anonymous,
The problem could be that the measure you used the ALL function on is not being applied to the bar chart's visual level. When you interact with the bar chart by selecting a year, it could be filtering the visual level and therefore changing the calculation of your measure.
To solve this issue, you can try applying the same ALL function to the visual level of the bar chart as well. To do this, go to the "Visualizations" pane, click on the bar chart, and then go to the "Filters" section. Add your measure to the filters section and then click on the "Advanced controls" option. From there, select "Don't filter the measure" and then apply the ALL function to the visual level using the formula bar.
This should ensure that the measure is not affected by the bar chart's visual level and remains constant regardless of any interaction with the chart.
Best regards,
Isaac Chavarria
If this post helps, then please consider Accepting it as the solution and give Kudos to help the other members find it more quickly
User | Count |
---|---|
77 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
100 | |
91 | |
83 | |
61 |