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 Guys.
I'm stuck and can't get free.
Model below with dynamic columns.
https://drive.google.com/file/d/1bAEMtI30Nq1TT6fVzie9WLCYzwtoGiJV/view?usp=sharing
Varying the month, the activities get planned, started, finished, change.
At first I wanted just like Count Results from a Measure.
I solved it by creating 3 measures, with Measure F = COUNTROWS(FILTER('TP',[#Dynam Status] = "Finished")). And putting the 3 in Pie.
I thought, this solves it...while in Pie Grafic I noticed a problem.
It has the count, but it has no link with the table.
I would like to click on a status in the Pie Chart and it filters out all the activities for that Status.
Thanks!
Solved! Go to Solution.
https://community.powerbi.com/t5/Desktop/Count-Results-from-a-Measure/m-p/2535592/highlight/true#M89...
I asked the similar question, but incompletely, the same was answered for me.
https://community.powerbi.com/t5/Desktop/Count-Results-from-a-Measure/m-p/2535592/highlight/true#M89...
I asked the similar question, but incompletely, the same was answered for me.
You can avoid all these issues (and measures) by bringing your source data into a better format.
Instead of
you will want to use
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |