Forum Discussion

Tae's avatar
Tae
Frequent Visitor
6 years ago

Creating a text parameter to dynamically change the X axis of visuals

Hi,   I'm thinking of creating a workforce snapshot dashboard which has the ability to drill down into the lowest level management/business unit. I understand that the hierarchy slicer allows me t...
Need Help
Tips and Tricks
v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Tae ,

 

Please try to create a calculated table instead of a measure.

 

 


Best regards,

 

Tae's avatar
Tae
Frequent Visitor
6 years ago

Thanks Dong.

This is the table I get.

I don't know why but the lower level hierarchies are consolidated into the highest level - BUSINESS GROUP.

 
Axis = UNION (
CROSSJOIN ( { "Level 1" }, DISTINCT ( dashboard[BUSINESS_GROUP] ) ),
CROSSJOIN ( { "Level 2" }, DISTINCT ( dashboard[DIVISION]) ),
CROSSJOIN ( { "Level 3" }, DISTINCT ( dashboard[DEPARTMENT_REGION]) )
)
  • v-lid-msft's avatar
    v-lid-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Tae ,

     

    Sorry for forgetting to mention that we change the column name in our workaround. the BUSINESS_GROUP is just a auto-generate column name.


    Best regards,