Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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


fig1                                                                                                                                                         fig2
Help

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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's avatar
        qqqqqwwwweeerrr
        Icon for Solution Sage rankSolution Sage
        2 years ago

        Hi Anonymous 

         

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

         

        Regards