Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Custom Label do not work with reverse stack order

Submitted by Anonymous on ‎06-15-2023 08:56 PM

PowerBI has just introduced Measure driven data labels in their May 2023 Update, and it is a great feature to visualize.

 

I have used the feature to create a visualization.

JusticeJr_0-1686887601477.png

The custom labels work great. However, I want to reverse the stack order to match the legend order.

 

When I turn on Reverse stack order, it shows like this.

JusticeJr_1-1686887669151.png

The percentage shows the right value, but the columns do not reflect it (it says 0% for legend E, but the column height is for legend A)

 

I think this is a bug for new features like this. I hope it will be solved in the near future.

Status: Investigating

Hi @Anonymous ,

By my test, the height is not corresponding to the data label.

vyanjiangmsft_0-1687254261832.png

But my concern is, just for the function "reverse stacked order", if I use the default data label instead of measure driven data, it performs the same as resort legend. I think it's the correct result. As after we reverse stack order, the color of each legend did not change, if the data label also don't change, it will not be the correct data.

label2.gif

Best regards,

Community Support Team_yanjiang.

See more ideas labeled with:
6 Comments (6 New)
Comments
v-yanjiang-msft
Community Support
Community Support
‎06-19-2023 01:55 AM
Status changed to: Needs Info

Hi @Anonymous ,

By my test, it works fine, please see the below gif:

label.gif

Best regards,

Community Support Team_yanjiang

Anonymous
Not applicable
‎06-19-2023 02:01 AM

Hi @v-yanjiang-msft ,

I think you misunderstood my ideas.

I want to REVERSE ONLY THE STACK ORDER, not also the SORT LEGEND. Because when we sort the legend, the stack order will also be reversed. I just want 1 thing (Stack Order or Legend) to change.

Best regards,

v-yanjiang-msft
Community Support
Community Support
‎06-19-2023 11:18 PM

Hi @Anonymous ,

Sorry I'm not quite clear what's "reverse only the stack order" means, in my understanding stack order and legend are the same.

 

Best regards,

Community Support Team_yanjiang

Anonymous
Not applicable
‎06-19-2023 11:43 PM

Hi @v-yanjiang-msft, 

This is the "Reverse stack order" that Power BI released in October 2022. It allows stacked column to be flipped without changing the legend order.

JusticeJr_0-1687243257790.png

Best regards,

 

v-yanjiang-msft
Community Support
Community Support
‎06-20-2023 02:53 AM
Status changed to: Investigating

Hi @Anonymous ,

By my test, the height is not corresponding to the data label.

vyanjiangmsft_0-1687254261832.png

But my concern is, just for the function "reverse stacked order", if I use the default data label instead of measure driven data, it performs the same as resort legend. I think it's the correct result. As after we reverse stack order, the color of each legend did not change, if the data label also don't change, it will not be the correct data.

label2.gif

Best regards,

Community Support Team_yanjiang.

Anonymous
Not applicable
‎06-20-2023 02:59 AM

Hi @v-yanjiang-msft ,

Yes, it didn't correspond to the measure-driven data only. When I use the default data label, it will work as intended.

Looking forward to your next update.

Best regards,

Idea Statuses