How to apply a filter to other visuals on a page, when a specific measure is clicked in a table?

Anonymous — Wed, 13 Sep 2023 10:18:05 GMT

Hi guys,

Hope all is well!

I was hoping someone could help me...

I've created a matrix where the date is the columns, and the rows are a series of measures (see below):

I have another table on the same page which has the specific accounts. I'd like to have it so if I click on a value in the top matrix which is the measure (for example) 'breakdown_upsell' and the month 'May', the table in the bottom filters for Tag = 'Upsell' and CalendarDate = 'dates in May'. As you'll see in the screenshot below, when the value for 'breakdown_upsell' and 'May' is selected, the second table does filter for the month of May, but it still includes other 'Tags' (Cross sell and New Business). However, I want it to just show 'Upsell' in May (see below):

This is the forumula I've used for the measure 'breakdown_upsell':

breakdown_upsell =

CALCULATE(

SUM('Sales Fact_MRR2'[variance]),

FILTER('Sales Fact_MRR2', 'Sales Fact_MRR2'[tag] = "Upsell")

)

Can someone please help?

Thanks in advance!!

Re: How to apply a filter to other visuals on a page, when a specific measure is clicked in a table?

lbendlin — Sun, 17 Sep 2023 23:47:04 GMT

That should be automatic based on your data model.

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

topic Re: How to apply a filter to other visuals on a page, when a specific measure is clicked in a table? in DAX Commands and Tips

How to apply a filter to other visuals on a page, when a specific measure is clicked in a table?

Re: How to apply a filter to other visuals on a page, when a specific measure is clicked in a table?