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

[rambler]

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!

[v-xicai]

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

[rambler]

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

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.

Best Regards,

Amy

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