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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
pceglie
Resolver I
Resolver I

Filtering by 2 criteria

Hi, I have a report with a Slicer:

1. filter Year

2. filter Month 

3. filter ProductCategory (single value selected)

 

the report contains a list of customers with total Revenue per selected category and it works well.

 

The question is: how can I add a filter to perform a compare from the selected Category and another one (prompted by user) keeping the filter on Yer/Month/Customer?

 

Thanks,

7 REPLIES 7
Greg_Deckler
Super User
Super User

I am not clear on what you are trying to do. Can you post some sample data and your expected result, perhaps some mocked-up screen shots?


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Hi, look at the example below

Cattura.PNG

I need a column in the table that contains the total Qty ordered by second filter-

So I need to analyze the total Qty ordered for the year 2016, and for filter SIZE1 = 1.5m and I need to compare the same value for the filter 2 (for example Size = 10m)

The problem is that when I apply the filter SIZE1 obviously SIZE2 is just filtered too.

How can I obtain the desired result?

Thanks

Got it. Use "Edit Interactions". So click your size slicer, in ribbon under Visual Tools, click "Format". On the far left is "Edit Interactions". When you do this, you will see little icons appear on all of your other visualizations. Click on the "Ghostbuster" icon to turn it off on the visuals you do not want to be affected by selections on the selected visualization. I use this extensively on the second page of my data story "Ohio Primary and Secondary Education":

http://community.powerbi.com/t5/Data-Stories-Gallery/Ohio-Primary-and-Secondary-Education-Performanc...

 

Note, in your case, I imagine that you would have 2 identitical tables. Year would filter both. Your first size would only filter your first table. Second size filter would only filter your second table.


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

You're right!

But how can I add a column (measure) that refers to that filter (the second one)?

Hi @pceglie,

 

Do the slicer SIZE1 and SIZE2 contain the exactly same options? That is to say you added the same column to these two filters. If so, now you want to analyze the total Qty ordered for the year 2016 under SIZE = 1.5m and SIZE = 10m, why don't you consider to use only one slicer and enable multiple selections. 

 

Turn off the Single Select. Then you can select both SIZE = 1.5m and SIZE = 10m in slicer and the filtered data you want to compare will display in the same table visual.

4.PNG

 

If you still have any question, please feel free to ask.

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-yulgu-msft, this is only an example. The real report is more complex than this. I can't use multi-select on the slicer because I need only one column of the table (the last one) will be interested by the second slicer.

Then you add that column (the one that is interested) as your slicer?


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.