Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
TungNguyen_19
Helper III
Helper III

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?

TungNguyen_19_0-1705846593033.png

Thank you

 

1 ACCEPTED SOLUTION
danextian
Super User
Super User

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.

danextian_0-1705897497988.png

 










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

View solution in original post

2 REPLIES 2
danextian
Super User
Super User

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.

danextian_0-1705897497988.png

 










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
Daniel29195
Super User
Super User

hello @TungNguyen_19 

yes you can

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

Daniel29195_0-1705847250722.png

Daniel29195_1-1705847309702.png

 

 

 

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, 

Daniel29195_6-1705847958277.png

 

step 2 : change format to dynamic for the negative measure

Daniel29195_3-1705847821679.png

step 3 :  change from measure to format 

Daniel29195_4-1705847873376.png

 

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. 

Daniel29195_5-1705847889492.png

 

 

Daniel29195_2-1705847678116.png

 

 

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

 

best regards.

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.