Breakdown graph on Positive and Negative in axis for Text data

[Anonymous]

Hi, The requirement is to get a  chart (as attached) as below where the Brand Name is on X-axis and top axis must show 'positive' and if the value is 'Negative' then count must be shown on Negative axis for the data (as attached) . I created a column with a DAX saying if the value is "Positive" then 1 else -1 and then used it on chart and placed 'BrandName' and 'Review' on X axis and created custom column (with 1 and -1) on Y axis but here each Brand is shown up twice in x axis for Positive and Negative separately instead of being one single bar on positive axis and Negative axis.

Thanks

[Anonymous]

Hi @Anonymous ,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[Anonymous]

Hi @lbendlin Thank you for your reply.

I have added a Table here. I have tried to sketch out the expected output. All the 'Negative' review must show up on Negative axis and 'Positive' Review on Positive axis. X-axis represents the Brand Name( If Brand Name 'A' has both positive and Negative review, Brand name must not repeat on x-axis, just the positive Review count must be on Positive Yaxis and Negative on 'Negative' Yaxis.)

Brand Name	Review
A	Positive
B	Negative
C	Positive
D	Negative
E	Positive
A	Negative
B	Negative
C	Positive
D	Negative
E	Negative
A	Positive
B	Negative

[lbendlin]

see attached

[Anonymous]

Hi @lbendlin  Thank you very much for your time. As mentioned in the question, I have used this column of values with 1 and -1 and implemented on chart but is there any way to get the Datalabels on Negative axis to show up positive numbers? example '3' instead of '-3'

Thank you.

[lbendlin]

not unless you use custom visuals.