topic Re: column as a slicer in DAX Commands and Tips

column as a slicer

Anonymous — Tue, 27 Feb 2024 12:26:37 GMT

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

fig2

Re: column as a slicer

qqqqqwwwweeerrr — Tue, 27 Feb 2024 16:20:19 GMT

Hi Anonymous

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

Re: column as a slicer

Anonymous — Thu, 29 Feb 2024 06:46:55 GMT

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.

Re: column as a slicer

qqqqqwwwweeerrr — Fri, 01 Mar 2024 06:10:35 GMT

Hi Anonymous

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

Regards