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
rambler
Regular Visitor

Dynamic source column in slicer based upon selected value in another slicer

Hi All


I've googled for this to no avail. I'm a total newbie as well.


What I am trying to do is change the source column of a slicer based upon the selection in another slicer.

 

For example, I have a table with the following columns:

Col1

Col2

Col3

I have two slicers, Slicer One & Slicer Two.

Slicer One contains the values Col1, Col2, Col3. Slicer Two contains dynamically variable values.

When I select one of these values from Slicer One (say, Col2), the source column of Slicer Two then becomes Col2.

If I then select Col3 from Slicer One, the source column of Slicer Two then becomes Col3.

 

I would imagine that a set of DAX queries would be the way forward, but am at a loss on how to implement them in slicers


A different solution would be to pivot the data. However this would create a table that would be too big to be useful.

 

Thanks in advance!

1 ACCEPTED SOLUTION
v-xicai
Community Support
Community Support

Hi @rambler ,

 

It is not supported to get dynamic source column in slicer based upon selected value in another slicer in Power BI Desktop currently .While you can post your new idea here https://ideas.powerbi.com/forums/265200-power-bi-ideas , to improve the Power BI Desktop.

 

It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 

To work around this issue, you can select the three columns Col1,Col2,and Col3 in Query Editor, right click and choose Unpivot columns. Then Put the Attribute into Slicer One. When make some selections(ex: select Col1 ) in Slicer One, it will return the Col1' content in Table visual or other visuals, you can choose some value in Table visual or other visuals, which equivalent to make some selections in the Slicer Two.

 

5.png6.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards,

Amy

 

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

3 REPLIES 3
v-xicai
Community Support
Community Support

Hi  @rambler ,
 
Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

 

Best regards
Amy

Hi Amy

 

Apologies for the very late response and many thanks for the detailed answer.

 

I have raised it here as an idea:

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/37661599-dynamic-source-column-in...

 

As mentioned, unpiovt columns would, for me, result in a table 100s of millions of rows long. However, this would potentially be a solution for other users.

 

Once again, many thanks for your help and advice 🙂

v-xicai
Community Support
Community Support

Hi @rambler ,

 

It is not supported to get dynamic source column in slicer based upon selected value in another slicer in Power BI Desktop currently .While you can post your new idea here https://ideas.powerbi.com/forums/265200-power-bi-ideas , to improve the Power BI Desktop.

 

It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 

To work around this issue, you can select the three columns Col1,Col2,and Col3 in Query Editor, right click and choose Unpivot columns. Then Put the Attribute into Slicer One. When make some selections(ex: select Col1 ) in Slicer One, it will return the Col1' content in Table visual or other visuals, you can choose some value in Table visual or other visuals, which equivalent to make some selections in the Slicer Two.

 

5.png6.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards,

Amy

 

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

 

 

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.

Top Solution Authors