Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Difference View in a Matrix

I have created a matrix visualization as attached in the screenshot.  The first column is the Year and the following columns are different values calulated based on business formulae.    In additio...
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Cherry,

 

There would be 2 dropdown boxes for the user to select dates (CORP_DATE is the column used for both drop-downs).

 

Based on the selected dates the difference in figures between the two selected dates should be displayed. 

 

For example, if the user selects 201712 (i.e. December 2017) and 201810 (i.e. October 2018) as the two dates in the , then the difference report will show the inception-to-date figures through October 2018 minus the inception-to-date figures through December 2017.

 

"Do you want to create two dropdown slicers and calculate the difference of the value based on the selected date value?" - Yes, this is what I want based on inception to selected date values as mentioned above.

 

Am I clear now? 

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Anonymous,

 

Do you have two date columns or one date column?

 

Do you want to create the list date slicer or other date slicer with the date column?

 

If it is convenient, could you share some data sample which could reproduce your scenario.

 

Best  Regards,

Cherry