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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Custom Label do not work with reverse stack order

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 @JusticeJr ,

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.

Comments
v-yanjiang-msft
Community Support
Status changed to: Needs Info

Hi @JusticeJr ,

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

label.gif

Best regards,

Community Support Team_yanjiang

JusticeJr
Frequent Visitor

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

Hi @JusticeJr ,

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

JusticeJr
Frequent Visitor

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
Status changed to: Investigating

Hi @JusticeJr ,

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.

JusticeJr
Frequent Visitor

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,