Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hello ,
I am new to power Bi learning and I am facing issue with my 1st project . Issue is my % grand total for count on X category is changing when i apply filter . Intial Bar Chart without filter
After I apply filter on "Discripancy status " and select "Error" . Then , the whole % changes as it's than only considering tptal of "Error" and ignoring count of "No error " . How do I fix this ? I have seen few articles but wasn't able to fix it . Any help with be highly appreciated
Solved! Go to Solution.
You are using a measure like for grand total (You can try using new Measure driven data labels, if needed )
divide([measure], calculate([Measure], all()))
or
divide([measure], calculate([Measure], allselected()))
Thank you ! It worked .
You are using a measure like for grand total (You can try using new Measure driven data labels, if needed )
divide([measure], calculate([Measure], all()))
or
divide([measure], calculate([Measure], allselected()))
User | Count |
---|---|
84 | |
79 | |
71 | |
47 | |
42 |
User | Count |
---|---|
109 | |
54 | |
50 | |
40 | |
40 |