Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply

column as a slicer

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


fig1fig1                                  
MorningStar_92_1-1709036637535.png                                                                                                                       fig2
1 ACCEPTED SOLUTION
qqqqqwwwweeerrr
Super User
Super User

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

 

 

View solution in original post

3 REPLIES 3
qqqqqwwwweeerrr
Super User
Super User

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

 

 

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. 

Hi @MorningStar_92 

 

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

 

Regards

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.