Forum Discussion
Dynamic source column in slicer based upon selected value in another slicer
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.
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:
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 :-)