Forum Discussion

pzeller's avatar
pzeller
Frequent Visitor
9 years ago
Solved

Custom Y Axis Labels

We are new to Power BI and are trying to create a chart that displays the # of open tasks for specific categories. We have a Total Open Tasks column and then we have a seperate column for each indivi...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    Hi pzeller,

     

    We can perform the pivot in DAX if you like.  

     

    If you create a calculated column like this

     

    Table 2 = UNION(
    SELECTCOLUMNS('Person',"Person",[Person ID],"Task Name" , "Task1" , "Value" ,[Task 1]),
    SELECTCOLUMNS('Person',"Person",[Person ID],"Task Name" , "Task2" , "Value" ,[Task 2]),
    SELECTCOLUMNS('Person',"Person",[Person ID],"Task Name" , "Task2" , "Value" ,[Task 3])
        )
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

Hi pzeller,

 

We can perform the pivot in DAX if you like.  

 

If you create a calculated column like this

 

Table 2 = UNION(
    SELECTCOLUMNS('Person',"Person",[Person ID],"Task Name" , "Task1" , "Value" ,[Task 1]),
    SELECTCOLUMNS('Person',"Person",[Person ID],"Task Name" , "Task2" , "Value" ,[Task 2]),
    SELECTCOLUMNS('Person',"Person",[Person ID],"Task Name" , "Task2" , "Value" ,[Task 3])
        )
pzeller's avatar
pzeller
Frequent Visitor
9 years ago

Thanks Phil_Seamark! With this we were able to figure out how to do it and achieve the desired look.