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?