Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Hi @dhoefler
Please check on these:
https://community.powerbi.com/t5/Desktop/Dynamic-Category-Using-a-Slicer/m-p/216971
Proud to be a Super User!
@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,
Lydia
Thank 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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |