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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!
User | Count |
---|---|
204 | |
70 | |
69 | |
57 | |
57 |
User | Count |
---|---|
251 | |
220 | |
105 | |
75 | |
74 |