Forum Discussion

ajohnso2's avatar
ajohnso2
Solution Supplier
2 years ago

DAX Dynamic Column population based on slicer selection

Hi All, Im looking for some advice and guidance with the below scenario. I would like to achieve this result without using Field Parameters if possible..? Some background: I have a hierarchy slice...
v-yanimei-msft's avatar
v-yanimei-msft
Community Support
2 years ago

Hi ajohnso2 , 

I see that the problem doesn't seem to be solved, so I'll give my reply. Hope it helps. Thank you for the detailed description. Based on your description, I think that the data cannot be displayed well. When you select Region Manager 1 and Region Manager 2, if only the next level of the list is displayed as shown in the picture, there will be an ambiguity between Area Manager 1 under Region Manager 1 and Area Manager 2 under Region Manager 2. I think it's the matrix that can show the data better, as shown in the following pictures. What data you want to see can be achieved by simply dropping down the matrix. To learn more about matrix, click Create a matrix visual in Power BI - Power BI | Microsoft Learn.

Finally, I attach my specific test table Table.

 

 

Best Regards,

Caroline Mei

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.