Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I have a column named "A" which has unique values. And another column "Adate" which has corresponding dates. They are not unique. I am using slicer for representing date, which shows count of "A" column which falls under the start date and end date selected.
I want a pie chart which shows count of A depending on the slicer and also total count of A before applying the slicer.
Eg: If total count is 200. And depending on the slicer, if the count changes to 90. I want a chart which shows 200 and 90.
What will the approach be?
Any help will be appreciated!
Thanks in advance
Solved! Go to Solution.
Not sure if I have understood this correction but here goes.
The following measures can both be added to a single pie visual. Measure 1 will only show the count of A within your date range, whereas Measure 2 will show the total count regardless. Like I said, I'm not sure if I have understood this, but lets see where this goes 🙂
Measure 1 = CALCULATE(COUNT(Table1[A]))
Measure 2 = CALCULATE(COUNT(Table1[A]),all('Table1'[ADate]))
Not sure if I have understood this correction but here goes.
The following measures can both be added to a single pie visual. Measure 1 will only show the count of A within your date range, whereas Measure 2 will show the total count regardless. Like I said, I'm not sure if I have understood this, but lets see where this goes 🙂
Measure 1 = CALCULATE(COUNT(Table1[A]))
Measure 2 = CALCULATE(COUNT(Table1[A]),all('Table1'[ADate]))
Thank you so much! It worked:)
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
71 | |
70 | |
38 | |
27 | |
26 |
User | Count |
---|---|
97 | |
96 | |
59 | |
44 | |
40 |