Create cards with charts where you can change columns on the X-axis through a filter.

I want to create a card (bar graph) where I can change the columns being shown on the x-axis through a filter. 

 

For instance, I have 4 columns: Revenue, Profit, Costs, Date. 

 

I always want Date to appear on the X-Axis. Whereas the columns on the Y-Axis should be any of the 3 (Revenue, Profit, Costs), depending on a filter that I put on the page (dashboard).  

 

Is there any way to do this? 

Best Answer

  • Ashleigh
    Ashleigh Coach
    Answer ✓

    @hamza_123  You should be able to do a grouped bar graph. Drag each column you want into the Series section. 

    **If this answer solved your problem be sure to like it and accept it as a solution!

Answers

  • Ashleigh
    Ashleigh Coach
    Answer ✓

    @hamza_123  You should be able to do a grouped bar graph. Drag each column you want into the Series section. 

    **If this answer solved your problem be sure to like it and accept it as a solution!

This discussion has been closed.