Forum Discussion
Create a conditional column in Table based on slicer selection
I need to create a customized table that enables users to select which dimension(s) they would like to have for the measure(s).
For example, I have a table like below:
| Item | Region | Country | Unit Sold |
| A | e | h | 100 |
| A | e | i | 200 |
| B | f | j | 300 |
But now, I would like to have the column Region and Country be dynamic according to the selection of the corresponding dimensionSlicer. That is, I have two dimensionSlicers like below:
dimensionSlicerA
| ValueA |
| Region |
| Country |
| Show Blank |
dimensionSlicerB
| ValueB |
| Region |
| Country |
| Show Blank |
If the user selects 'Region' in dimensionSlicerA and 'Show Blank' in dimensionSlicerB, the original table will then be:
| Item | Region | Show Blank | Unit Sold |
| A | e | 300 | |
| B | f | 300 |
1 Reply
You cannot create a calculated column or calculated table from a measure.
