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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
diogobraga2
Helper IV
Helper IV

Two values in 100% stacked bar, but show label for only one

How do I show label only for the value (utilization rate) being represented in light blue here?

 

2019-12-21_1915.png

1 ACCEPTED SOLUTION

Hi @diogobraga2,

In fact, you can also use Dax formula to create a table with unpivoted records. Please refer to the below blog to learn how to use 'UNION' and 'SELECTCOLUMNS' functions to create a calculated table with expanded records:

DAX Unpivot 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

7 REPLIES 7
v-shex-msft
Community Support
Community Support

HI @diogobraga2 ,

I'd like to suggest you do 'unpivoted columns'(query editor) on your value fields 'utilization rate' and 'not utilization rate', then you can modify your visual design to use 'attribute' on legends and 'value' on values.

Unpivot columns (Power Query) 
After these operations, you can simply use filters to control which attributes to display.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

By the way, the original dataset has only 'utilization rate' and that's the value that matters. I create the 'not utlization rate' by calculating 1-'utilization rate' since 100% is the maximum and I must show the utilzation out of 100%. Is there another way to show the 'utilzation rate' within a 100% bar axis to visualize this, without creating the 'not utilization rate' calculation therefore not needing to pivot to rows. Any ideas here? 

 

If creating the 'not utilization rate' calculated column (the way I am doing now) is the only way...then it sounds like I will have to create another table to pivot the columns to rows. 

 

 

Hi @diogobraga2,

In fact, you can also use Dax formula to create a table with unpivoted records. Please refer to the below blog to learn how to use 'UNION' and 'SELECTCOLUMNS' functions to create a calculated table with expanded records:

DAX Unpivot 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

@v-shex-msft can you please provide your feedback on this?

 

I got the following error message:

 

DAX comparison operations do not support comparing values of type Number with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.

 

2019-12-28_1109.png

Hi @diogobraga2 ,

It seems like your utilization column stored numeric values and you are trying to compare text value with numbers.  For this scenario, I'd like to suggest you use blank() to replace "" to fix this issue.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
amitchandak
Super User
Super User

If possible please share a sample pbix file after removing sensitive information.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.