we are stuck in how should we design this if we have a single table as below
I have a tab with 2 visuals one table which shows Monthly data and one line chart for the same.
we have to make 2 slicers on same page as below
1, Type = Measure and show Desc values ( this will be used to dynamically change all the values on page( both line chart and Table values) for example If user selects Case show values in Cases, similarly is user selects Gross Sales show all the Sales Value.)
- Type = Selection and show Alternative Desc values ( this will be used to dynamically change the line chart values base on selection by the user.)
When I am selecting Case or Sales the table values are changing but line chart is coming blank. For line Chart there are 2 filters… one is the case and second is Selection value. As soon as I select Case the alternative desc also comes Case and the line chart is not getting values.
Is it possible to use the same table or do we need to create 2 tables.
Hope I am clear.