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 ,

 

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?


Best regards,

 

Tae's avatar
Tae
Frequent Visitor
6 years ago

Hi Dong,

 

When I try to create the axis table, I get an warning message saying "the expression refers to multiple columns. Multipler columns cannot be conversted to a scalar value".

 

 

Regards,

Tae

  • 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,