Can we create the chart like this?

[TungNguyen_19]

Hi everyone,

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

Thank you

[danextian · Accepted solution]

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.

[Daniel29195]

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.