Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Cluster values on X axis bar chart

I have 4 different measures calculation percentage.  I am looking for a way to cluster the bars in pairs and add x values to each cluster like this: (0-100.000, >100.000-500.000) etc.     ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    You can try to create a separate table as follows, then reference them in the measure, and map them accordingly.

     

    The measure is just like

     

    Measure =
SWITCH (
    MAX ( 'Table'[Range] ),
    "0-100000",
        CALCULATE (
            SUM ( 'Table (2)'[Values] ),
            FILTER ( 'Table (2)', [Values] > 0 && [Values] < 100000 )
        )
)

     

     

    Best Regards,

    Stephen Tao

     

    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
5 years ago

Hi Anonymous ,

 

You can try to create a separate table as follows, then reference them in the measure, and map them accordingly.

 

The measure is just like

 

Measure =
SWITCH (
    MAX ( 'Table'[Range] ),
    "0-100000",
        CALCULATE (
            SUM ( 'Table (2)'[Values] ),
            FILTER ( 'Table (2)', [Values] > 0 && [Values] < 100000 )
        )
)

 

 

Best Regards,

Stephen Tao

 

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