Forum Discussion
Change column in visual based on measure value
I have in my report a table called Departments, with the following structure:
| DepartmentName | L1 | L2 | L3 | L4 |
| DP/MNG1 | DP | MNG1 | null | null |
| DP/MNG1/SUB1 | DP | MNG1 | SUB1 | null |
| DP/MNG1/SUB2 | DP | MNG1 | SUB2 | null |
In the report there a Data Segmentation visual, with L1, L2, L3 and L4. Additionally, I have a measure thats successful calculate the SegmentationLevel (if is a L2 department, it return 2).
In same report I have a Table visual like this, that works:
| DepartmentName | Value |
| DP/MNG1/SUB1 | 20 |
| DP/MNG1/SUB2 | 10 |
| ... |
But I don't want to display full department, because my company have really big org and there is no reason to unfold so much when a higher org is selected. I need to choose the column based on SegmentationLevel measure. Example: If I segment by L1 = DP and L2 = MNG1, the SegmentationLevel measure will be 2 and I would like Column L3 instead of DepartmentName on Table Visual.
I have tried to calculate, but can't get column based on measure value. Any idea on how to achieve this?
2 Replies
- vanessafvg
Community Champion
can you share what you have done and can you please provide an example of the expected output of the value in the table
- eneasgesingNew Member
Thank you for your support.
I generated an example file where I show data and explain what I'm trying to do:
Hope you can help me with it.