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.
Hi Power BI Experts,
Is there a DAX formula to prevent the 100% bar chart from recalculating percentages if I exclude a category?
Here is my DAX.
But if I exclude a percentage, the graph is recalculated.
I thought the Remove filters statement would prevent the recalculation but it does not.
Solved! Go to Solution.
@Anonymous , 100% Stacked bar chart will calculate its own %. You can calculate % and use the Stacked bar visual, there removefilter, all , all except can help as per need
Divide([Meausre], calculate([Meausre], removefilter(Table, Table[Legend])) )
@Anonymous , 100% Stacked bar chart will calculate its own %. You can calculate % and use the Stacked bar visual, there removefilter, all , all except can help as per need
Divide([Meausre], calculate([Meausre], removefilter(Table, Table[Legend])) )
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |