Filtering between Visualizations

[SandeA]

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 

[mwegener · Accepted 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.

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.

[mwegener · Accepted solution]

Hi @SandeA ,

it won't be dependent on the version.

It does not work

It does not work

It works

It works

[mwegener · Accepted 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.

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.

[SandeA]

@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 · Accepted solution]

Hi @SandeA ,

it won't be dependent on the version.

It does not work

It does not work

It works

It works

[SandeA]

@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 · Accepted solution]

Hi @SandeA ,

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

[SandeA]

You ROCK!!! Thank you so much!

[SandeA]

@mwegener 

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

[SandeA]

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

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

[mwegener]

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.

[SandeA]

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

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