cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Aristocrazy
Helper I
Helper I

One Slicer depending on the slicer selection

Hi Folks,

 

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.

 

3.png.jpg5.jpg

1 ACCEPTED SOLUTION

Hi @Aristocrazy,

Looking at your data believe that the best option is to unpivot your table and the use the column variable as you slicer for level 1 to level 5,that way since the slicer are from the same table no need to have additional tables.


Regards,
MFelix

Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

8 REPLIES 8
parry2k
Super User
Super User

@Aristocrazy can you share how your tables are connected. Is there relationship between these tables? 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Thank you for your answer.

 

There is no connection between these tables. 

 

This is the Slicer1 Table:

 

Slicer1.png

 

This is the table I need to filter between different columns (Nivel1, Nivel2,...)

 

Niveles.png

 

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.

todo.png

 

 

Apreciate your help, thank you.

Hi @Aristocrazy,

Looking at your data believe that the best option is to unpivot your table and the use the column variable as you slicer for level 1 to level 5,that way since the slicer are from the same table no need to have additional tables.


Regards,
MFelix

Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

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.

@Aristocrazy,

Don't understand what you mean by "want the user to select... Without choosing any column".

Making this type of treatment to your data will make it easier to slice and dice and format your visuals, when having information in several columns that you need to have the slicers being interchangeable believe the best option is to unpivot that will decrease the need for further calculations or measures.

Regards,
MFelix

Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



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 

@Aristocrazy 

 

You may take a look at the following posts.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@Aristocrazy solution proposed by @MFelix is the way to go, it is more scalable and best way to deal with such a scenario.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!