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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
krmol21
Frequent Visitor

Urgent! Need Help with Filtering a Table with 2 Unrelated Slicers

Hello community,

I'm trying to get my 2 product slicers, based on unrelated product tables DIM_PRODUCT and DIM_PRODUCT_2, to filter one product table and show both products and their Volume measure. Basically, I want Product B, coming from DIM_PRODUCT_2 and selected in the 2nd slicer, to show as a 2nd row in my table with its Volume measure: Volume = sum(FACT_VOLUMES[VOLUME]). Currently only Product A, coming from DIM_PRODUCT table, is showing:

 

krmol21_2-1716380110416.png


Can you please help with with making both selected products show up in the table without creating any new relationships in the data model? I'm also attaching a screenshots of the model view and a link to the dashboard (sample version).

 

krmol21_0-1716483430044.png

Thank you!!

1 ACCEPTED SOLUTION
v-jianpeng-msft
Community Support
Community Support

Hi, @krmol21 

Have you already solved the current problem? To achieve this, you need to create a calculation table for both slicers as follows:

Slicer1Product = SUMMARIZE('DIM_PRODUCT',DIM_PRODUCT[PRODUCT])

vjianpengmsft_0-1717132558928.png

Slicer2Product = SUMMARIZE('DIM_PRODUCT_2','DIM_PRODUCT_2'[product])

vjianpengmsft_1-1717132608831.png

Put the two columns of these two tables into two slicers as follows:

vjianpengmsft_2-1717132699998.png

vjianpengmsft_3-1717132720457.png

Create a new measure using the following DAX expression:

tag = 
VAR _slicer1 = SELECTCOLUMNS('Slicer1Product','Slicer1Product'[PRODUCT])
VAR _slicer2 = SELECTCOLUMNS('Slicer2Product','Slicer2Product'[product])
RETURN IF(SELECTEDVALUE(DIM_PRODUCT[PRODUCT]) IN _slicer1 || SELECTEDVALUE(DIM_PRODUCT[PRODUCT]) IN _slicer2,1)

Place this measure on the visual filter panel and set it to a value of 1:

vjianpengmsft_4-1717132911814.png

Here are the results:

vjianpengmsft_5-1717132956344.png

vjianpengmsft_6-1717132974674.png

vjianpengmsft_7-1717133007026.png

 

 

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

 

 

View solution in original post

4 REPLIES 4
v-jianpeng-msft
Community Support
Community Support

Hi, @krmol21 

Have you already solved the current problem? To achieve this, you need to create a calculation table for both slicers as follows:

Slicer1Product = SUMMARIZE('DIM_PRODUCT',DIM_PRODUCT[PRODUCT])

vjianpengmsft_0-1717132558928.png

Slicer2Product = SUMMARIZE('DIM_PRODUCT_2','DIM_PRODUCT_2'[product])

vjianpengmsft_1-1717132608831.png

Put the two columns of these two tables into two slicers as follows:

vjianpengmsft_2-1717132699998.png

vjianpengmsft_3-1717132720457.png

Create a new measure using the following DAX expression:

tag = 
VAR _slicer1 = SELECTCOLUMNS('Slicer1Product','Slicer1Product'[PRODUCT])
VAR _slicer2 = SELECTCOLUMNS('Slicer2Product','Slicer2Product'[product])
RETURN IF(SELECTEDVALUE(DIM_PRODUCT[PRODUCT]) IN _slicer1 || SELECTEDVALUE(DIM_PRODUCT[PRODUCT]) IN _slicer2,1)

Place this measure on the visual filter panel and set it to a value of 1:

vjianpengmsft_4-1717132911814.png

Here are the results:

vjianpengmsft_5-1717132956344.png

vjianpengmsft_6-1717132974674.png

vjianpengmsft_7-1717133007026.png

 

 

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

 

 

Hi @v-jianpeng-msft , thanks a lot for your suggested apporach, it does work, however, I was wondering if you know if there is a way to keep original DIM_PRODUCT[PRODUCT] and DIM_PRODUCT_2[product] fields in the slicers and make them work in the intended way?

 

The reason I'm asking is

1) I don't quite understand how the 2 summarized tables you created are different from the original DIM tables (why the intended filtering works only with your suggested approach)

2) I have other pages and measures that depend on these slicers, so changing the fields in the slicer means changing them across the whole dashboard, so want to check if you know a way to avoid using new fields in the slicers.

 

Thank you again!

Shivu-2000
Resolver III
Resolver III

Hi @krmol21,

Can you share us some sample data and report.


Hi @Shivu-2000, I have attached a link to the sample report: https://drive.google.com/file/d/1lERA92omXsJ9CAIX01-vVRWVShAvMf5h/view?usp=sharing 

Thanks!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors