Forum Discussion
Breakdown graph on Positive and Negative in axis for Text data
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
6 Replies
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/1447523Hi 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 see attached
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
