As usually I need your wisdom, experience and help!
I post a coulpe of pictures in order to help to understand where I'm stuck at.
The Slicer selector (1) is a new table I have created just with values "Nivel1, Nivel2, ..., Nivel5".
The Slicer2 is a column from the item category table.
I need a "Slicer selector"(1). The function of this slicer is to be selected by the user between 5 options "Nivel1, Nivel2,... Nivel5" and when user selects the option, the other Slicer (2) has to change depending on the selection of Slicer1, as it figures on the pictures I posted.
I know the "trick" " Measure 1 = Switch( true(); Values( ...))" but I don't know how to set it up, because I don't have any measure.
Thank you and sorry for my english!
Merry Christmas to everyone.
Solved! Go to Solution.
Thank you for your answer.
There is no connection between these tables.
This is the Slicer1 Table:
This is the table I need to filter between different columns (Nivel1, Nivel2,...)
What I need to do is depending on the selection in the first Slicer (Nivel3, for example), the other Slicer has to change to Nivel3 selection/column.
Apreciate your help, thank you.
First of all, thank you for taking your time answering and trying to help 🙂
Yes, that's my "Plan B".
I need this because I want user to select Nivel1...Nivel5 from the main canvas, without selecting any columns. Just click, click, click.
Sorry, I don't understand you when you say "unpivot the table". English is not my main language and I'm not a pro powerquery user. Could you give me an accurate example please? I'd appreciate it.
Sorry for the inconvenience and thank you @MFelix
You may take a look at the following posts.
Learn how to create your own user groups today!
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!