topic Re: Breakdown graph on Positive and Negative in axis for Text data in Developer

Breakdown graph on Positive and Negative in axis for Text data

Anonymous — Fri, 05 Jul 2024 23:42:44 GMT

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

Re: Breakdown graph on Positive and Negative in axis for Text data

lbendlin — Sat, 06 Jul 2024 18:52:08 GMT

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-Forum/ba-p/963216

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/1447523

Re: Breakdown graph on Positive and Negative in axis for Text data

Anonymous — Mon, 08 Jul 2024 10:38:16 GMT

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

Re: Breakdown graph on Positive and Negative in axis for Text data

lbendlin — Mon, 08 Jul 2024 19:27:19 GMT

see attached

Re: Breakdown graph on Positive and Negative in axis for Text data

Anonymous — Thu, 11 Jul 2024 00:02:29 GMT

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.

Re: Breakdown graph on Positive and Negative in axis for Text data

lbendlin — Thu, 11 Jul 2024 00:06:23 GMT

not unless you use custom visuals.

Re: Breakdown graph on Positive and Negative in axis for Text data

Anonymous — Wed, 14 Aug 2024 07:13:24 GMT

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