column as a slicer

[MorningStar_92]

i have a sales , discounts etc columns, i want to use these columns as a slicer but i'm getting range of values as they are numerical values. But , i want it in such a way that slicer only shows sales,discounts and as soon as i click it, the table and graph should show only sales value.
figure 1 shows the data and fig2 is how i want my dashboard, the graph should show sales data as soon as i click sales, similarly for profit discounts etc. 
if there is another way like using buttons or anything im open for that suggestion too. 
pls Help


fig1                                                                                                                                                         fig2

[qqqqqwwwweeerrr · Accepted solution]

Hi @MorningStar_92 

Check this video it might help you. The only thing you need to add is one more switch case: https://youtu.be/e5q1pW45xRk?si=VxYmS-ed_GJyWaBa

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: https://www.youtube.com/@letssolveproblem

Regards

[MorningStar_92]

Hey Thanx for the Solution. 
Moreover i wanted to ask if we can put these into 1 clustered graph. i mean i want to show sales discount and profit in one graph so that i can compare 3 values in 1 graph. 

[qqqqqwwwweeerrr]

Hi @MorningStar_92 

You can create three measure for respective fileds and use in cluster column chart it will work.

Regards