Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get 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

Reply
SandeA
Helper III
Helper III

Filtering between Visualizations

Hello! I have a dashboard with 3 charts, a table, and 4 cards along with 2 slicers at the top:

Dashboard1.jpg

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:

Dashboard2.jpg

However, when I click on an item in the table on the right, it filters all of the visuals

Dashboard3.jpg

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 

3 ACCEPTED SOLUTIONS
mwegener
Most Valuable Professional
Most Valuable Professional

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.

PBIX

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.

Did I answer 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


View solution in original post

mwegener
Most Valuable Professional
Most Valuable Professional

Hi @SandeA ,

 

it won't be dependent on the version.

It does not work

It does not workIt does not work

It works

It worksIt works

Did I answer 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


View solution in original post

mwegener
Most Valuable Professional
Most Valuable Professional

Hi @SandeA ,

 

it should look something like this. (a measure and request type as legend)

StatusBarFilter.png

Did I answer 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


View solution in original post

11 REPLIES 11
mwegener
Most Valuable Professional
Most Valuable Professional

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.

PBIX

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.

Did I answer 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


@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!

mwegener
Most Valuable Professional
Most Valuable Professional

Hi @SandeA ,

 

it won't be dependent on the version.

It does not work

It does not workIt does not work

It works

It worksIt works

Did I answer 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


@mwegener 

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. 😞 

mwegener
Most Valuable Professional
Most Valuable Professional

Hi @SandeA ,

 

it should look something like this. (a measure and request type as legend)

StatusBarFilter.png

Did I answer 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


You ROCK!!! Thank you so much!

@mwegener 

Thank you so much! that worked like a charm! 🙂 

@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! 

v-gizhi-msft
Community Support
Community 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:

Support Ticket.gif

 

Best Regards,

Giotto Zhi

mwegener
Most Valuable Professional
Most Valuable Professional

Hi @SandeA ,

 

check this out...

https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions#change-the-interaction...

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.

Did I answer 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


@mwegener 

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:

ReportInteractions.jpg

The interactions between the visuals and the report are all set. I just don't understand why they don't appear to be working. 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.