Forum Discussion

sivaadityat's avatar
sivaadityat
Frequent Visitor
2 years ago
Solved

Visualize bins with unique measure values

Hello All,   I got a requirement in Headcount utilization with below scenario. I am looking a help to visualize bar chart with both measures in X and Y axis.   Scenario: I have calculated headcou...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi sivaadityat ,

    Please try to create a calculate column with VAR keyword, use the VAR keyword to define the based calculate logic.

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi sivaadityat ,

Please try to create a calculate column for bins, then add it to the X axis.

In Power BI, X axis do not support measure.

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

sivaadityat's avatar
sivaadityat
Frequent Visitor
2 years ago

Hi Anonymous 

 

Thanks for the reply. I tried calculating calculated column for binning for this issue. But, as I am calculating this bins based on a measure value, it is giving a aggrigated value for all rows.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi sivaadityat ,

    Please try to create a calculate column with VAR keyword, use the VAR keyword to define the based calculate logic.

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.