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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Reverse Legend and Values

Hi,

 

How can I get this changed so that I see the 3.6% and 1.1% on the left and the 1.3% and -1.2% on the right?

 

The left is Customer 1 and the right is Customer 2.

 

gmooney10_0-1640653080234.png

 

4 REPLIES 4
v-rongtiep-msft
Community Support
Community Support

Hi @Anonymous ,

I am not understand your meaning. How about creating visuals by yourself?

Please refer to the following document about creating visuals.

https://docs.microsoft.com/power-bi/developer/visuals/develop-circle-card

 

If I have misunderstood your meaning, please reply me and provide more details.

 

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

parry2k
Super User
Super User

@Anonymous This can be easily achieved with the Calculation Group. Create a calculation group with two items Sales % Chg and Unit % Chg and each calculation item should return the respective measure

 

In visualization, put the Calculation Group name on the x-axis, the column you are currently using on the x-axis, use it on legend, and drop one of the measures on the value, and this will do it.

 

Here is an example of it where Qty and Sales are grouped together and showing the same for each year.

 

parry2k_0-1640662117662.png

 

Follow us on LinkedIn

 

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous
Not applicable

@parry2k 

 

Are there any free Calculated Group options for PBI Desktop?

amitchandak
Super User
Super User

@Anonymous , You can control label position, in that you have an option for customize series.

Then for each measure, you can change the position. But I doubt you can change for the value of the axis.

 

Also options are not for left/right

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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