Forum Discussion
combined table
We used calculated columns to get the desired table, so using slicer here is not work as expected, unless we use calculated measure.
But using calculate measures, we will not be able to get the desired table format, the only way is to use two table visuals.
Best Regards,
Herbert
In such scenario, we may need to create another table and some calculated columns as a trick.
The new created table needs to have a column which includes Category A, B, and Gap like following screenshot. Then we can use IF function to do the desired calculations.
For details, please refer to attached PBIX file.
Best Regards,
Herbert
Hi v-haibl-msft,
This is awesome. I got the concept & managed to create the format.
However, I faced another challenge.
I have 2 slicers from the raw data table, i.e. Table 1 in this example, i.e. entity & month.
Need a further advise, how can I link the slicers to the new table?
We used calculated columns to get the desired table, so using slicer here is not work as expected, unless we use calculated measure.
But using calculate measures, we will not be able to get the desired table format, the only way is to use two table visuals.
Best Regards,
HerbertHi v-haibl-msft,
Thanks for the explanation.
It's not what I expected, since it took an amount of time to do the setting (for example format, interactions, etc)
But, I can live with separated tables for now :smileyhappy:
Thanks again.