Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
First time posting and a relatively new Power BI user here...
I'm trying to get the matrix table in a page to filter down to the values that contribute to a count value in an adjacent donut visual but no matter which value I select e.g. PCI Approval Durations [<15 Days], the matrix below returns the full list of PCIs rather than the two PCIs that make up the count total in that data value.
Essentially I want to be able to show all the counts of PCIs review durations in the donuts and then when I select one of the values it will show a filtered list below.
I've tried both from the SQL and DAX sides with case statements and a count expression, e.g. ApprovalDurLOW =
CALCULATE(COUNT(COR[ApprovalDur]),COR[ApprovalDur]<15), to show counts within each range but neither is causing the matrix to be filtered. I have checked to make sure that the donuts and matrix interaction relationships are correct so it must be something else I'm missing.
Any help would be greatly appreciated!
Sample data and visualization images here.
Solved! Go to Solution.
Hi @davebrown89,
althoug I don't know how you model is setup and your measure are made if you have the interactions active between the pie chart and the matrix table when clicking on one of the visual the other is filter accordingly, as you can see below I have a pie chart with a measure and the a matrix visualization when I select a value in the matrix the chart is filter and vice-versa.
Can you share some more details on your problem if possible a sample.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @davebrown89,
althoug I don't know how you model is setup and your measure are made if you have the interactions active between the pie chart and the matrix table when clicking on one of the visual the other is filter accordingly, as you can see below I have a pie chart with a measure and the a matrix visualization when I select a value in the matrix the chart is filter and vice-versa.
Can you share some more details on your problem if possible a sample.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
68 |