Forum Discussion

TungNguyen_19's avatar
TungNguyen_19
Icon for Helper III rankHelper III
2 years ago
Solved

Can we create the chart like this?

Hi everyone,

I want to ask that do we have any way to implement the chart like this one?

Thank you

 

  • Hi TungNguyen_19 ,

    If you're trying to move the negative reviews to the bottom, then you can create measure that multiplies the aggregation of negative reviews by negative 1 and use the native column chart. Attached is a sample pbix.

     

2 Replies

  • Daniel29195's avatar
    Daniel29195
    Icon for Community Champion rankCommunity Champion

    hello TungNguyen_19 

    yes you can

    you have 2 choices . 
    or you can use a custom visual :  tornado chart.

     

     

     

    or you can create a measure,  

    and play with its format .

    check below 

    step 1 :  create the measure you want to display

    one measure should be negative, and the other should be positive, 

     

    step 2 : change format to dynamic for the negative measure

    step 3 :  change from measure to format 

     

    step 4 :  write the following format  ( when you use the ;   -->  the one the left of the ; is for negative values, and the one on the right is for positive values. 

     

     

     

     

    NB in the second option, it is better to hide the values of the y-axis, 

     

    best regards.

     

  • Hi TungNguyen_19 ,

    If you're trying to move the negative reviews to the bottom, then you can create measure that multiplies the aggregation of negative reviews by negative 1 and use the native column chart. Attached is a sample pbix.