Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Solved! Go to Solution.
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.
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
Hi @SandeA ,
it won't be dependent on the version.
It does not work
It works
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
Hi @SandeA ,
it should look something like this. (a measure and request type as legend)
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
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.
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
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!
Hi @SandeA ,
it won't be dependent on the version.
It does not work
It works
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
I spoke to soon. The other visual, the bar chart of Requests by Type, is now having the same issue. I tried moving ReqType into the Legend like I did for ReqStatus but it wouldn't take. Power BI won't let me put anything in the Legend field. 😞
Hi @SandeA ,
it should look something like this. (a measure and request type as legend)
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
You ROCK!!! Thank you so much!
@mwegener - True! I forgot to mention that I was unable to open the file you sent because it was from a different version. That is one of the main reasons I need to update. These screenshots will help until I get everything updated to the newer versions though. 🙂
Thank you!
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 ,
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.
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
I understand the interactions but it just doesn't appear to be working. Here is a screenshot showing the interactions for the report to the visuals:
The interactions between the visuals and the report are all set. I just don't understand why they don't appear to be working.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
84 | |
84 | |
73 | |
49 |
User | Count |
---|---|
143 | |
132 | |
110 | |
64 | |
55 |