Forum Discussion
Filtering between Visualizations
Hello! I have a dashboard with 3 charts, a table, and 4 cards along with 2 slicers at the top:
My issue is that when I click on the Number of Requests by Status or Requests by Type visuals, it is not filtering any of the other visuals. The below screenshot shows the 'Edit Interactions' option turned on to see that all of them are set to filter when the visual is clicked on:
However, when I click on an item in the table on the right, it filters all of the visuals
Below is the breakdown of measures used in the 3 charts:
Total
TotalRequests = COUNT(Request2[PRR#])
Req by Status:
Closed = CALCULATE([TotalRequests],FILTER(Request2,Request2[ReqStatus]="Closed"))
InProgress = CALCULATE([TotalRequests],FILTER(Request2,Request2[ReqStatus]="In Progress"))
New = CALCULATE([TotalRequests],FILTER(Request2,Request2[ReqStatus]="New"))
OnHold = CALCULATE([TotalRequests],FILTER(Request2,Request2[ReqStatus]="On Hold"))
Req by Type:
AgencyReq = CALCULATE([TotalRequests],FILTER(Request2,Request2[RequestTypeId]=4))
CorporateReq = CALCULATE([TotalRequests],FILTER(Request2,Request2[RequestTypeId]=7))
GovernmentReq = CALCULATE([TotalRequests],FILTER(Request2,Request2[RequestTypeId]=6))
etc……
Req per Month
Same as Req by Status but with TotalRequests
Hi SandeA
Sorry, I misunderstood the problem. It was late.
The internal measure filter is not propagated. You have to insert the status column in the legend.
Check this out.
Regards,
Marcus
Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
11 Replies
Hi SandeA ,
check this out...
Check the interaction from the table to the other visuals.
Your screenshot shows the interaction between the donat chart and the other visuals.
Regards,
Marcus
Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.Hi，
After my test, it works fine here.
please try to update your Power BI Desktop to the latest version.
If you still have the same problem, i advise to create a support ticket:
Best Regards,
Giotto Zhi
Hi SandeA
Sorry, I misunderstood the problem. It was late.
The internal measure filter is not propagated. You have to insert the status column in the legend.
Check this out.
Regards,
Marcus
Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.mwegener and v-gizhi-msft
I noticed we are not on the most current version both for the Desktop and our On Premise server version. I've asked the DBA to update the server. When done, I'll update my Desktop version and try again.
Thank you!
