Forum Discussion
Solved
Dynamically calculate differences based on slicer slection
Hi, I am trying to present the data in a line and clustered column chart,date in the axis, company as column series, and Assets as the column value. In slicer, I have Company (A, B, C....F). ...
Please check if you can follow below steps. To make a better presentation, I'm using some data simple.
Suppose the dataset is as- Create an index column
rank = RANKX(Table3,Table3[Company],,,Dense)
- Create a measure
Measure = ABS((SUMX(FILTER(Table3,Table3[rank] = MIN(Table3[rank])),Table3[Revenue])-SUMX(FILTER(Table3,Table3[rank] = MAX(Table3[rank])),Table3[Revenue])))
- Drag a line and clustered column chart
Check more details in the uploaded pbix.
- Create an index column
Want to say the Solution posted worked perfectly!
what value will be displayed if nothing is selected in any of the slicers ? i am trying to achieve the chart where there are 3 columns the first two has impoterd values and third is ratio of rest two respectively. I have put two slicer year and reporting class(the data is sorted for same in the imported file) the problem I am facing is when nothing is selected in slicer it is adding all the ratios and showing instead i want it to do sum of each column respectively and show their ratio.