Forum Discussion
dynamic columns based on slicer selections
I have 2 table charts each with their own slicers for the user to select year, month and customer. I need a third table that will dynamically show the difference between the 1st and 2nd table values based on the slicers. For example, the user may select december 2017 in the 1st chart and may 2016 in the 2nd. The 3rd chard needs to subtract the values from the 1st chart and the 2nd chart for each column.
4 Replies
dhoefler,
Create a measure using DAX below in the first table, then drag the measure to Card visual. If the dax doesn't help, please share dummy data of the two tables and post expected result here.
DiffMeasure = SUM(Table1[column])-SUM(Table2[Column])
Regards,
LydiaThank you for the suggestion but not quite what I needed. I have 2 table graphs each with its own independent slicers. The 3rd table graph needs to dynamically figure the variance based on the slicers.
In the example below, I am expecting to see Segment = Covenience, Units = 32.890, Revenue = 22,524,699.03. Essentially, take the difference between the values in the 2 table charts, based on slicer selection, and display that in the 3rd table chart.
dhoefler,
Please share dummy data of the three tables, and describe the relationship among them.
Regards,
Lydia
- danextian
Super User
