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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
pmaurizi
Frequent Visitor

Two fileds, same visual, need to see all the data labels

Hi, I need help with this problem:

In a bar chart, I need to display two fields.

But not both together, but to show one or another, depending on the value selected in a slicer
One of the fields represents percentages, and the other represents absolute numeric values.


I use a stacked bar chart and it works fine.

But the problem is that for small values it does not show the data labels.


If I place only one of the fields in the chart, the data labels are shown, but if I place both, even if both are never shown together, it does not show the data labels.


How can I do to show one or the other field in the same chart, keeping each one its format (percentage or number), and always showing the data labels?


I attach screenshots to help understanding.

Thank you very much!

pmaurizi_0-1616516841685.pngpmaurizi_1-1616516921725.pngpmaurizi_2-1616517017164.png

 

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

Hi @pmaurizi ,

 

You can achieve this with bookmarks creating two visualizations

 

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-bookmarks

 

Or this can also be done using the calcuted groups with external tools.

https://docs.microsoft.com/en-us/analysis-services/tabular-models/calculation-groups?view=asallprodu...

 

https://www.fourmoo.com/2020/04/29/how-to-create-and-use-calculation-groups-in-power-bi-premium-azur...

 

However be aware that if you use this option you won't be abble to use implicit measures on your model anymore, meanig you cannot drag as column to a chart and make a sum or a count you will need to star using measures for all calculations.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

1 REPLY 1
MFelix
Super User
Super User

Hi @pmaurizi ,

 

You can achieve this with bookmarks creating two visualizations

 

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-bookmarks

 

Or this can also be done using the calcuted groups with external tools.

https://docs.microsoft.com/en-us/analysis-services/tabular-models/calculation-groups?view=asallprodu...

 

https://www.fourmoo.com/2020/04/29/how-to-create-and-use-calculation-groups-in-power-bi-premium-azur...

 

However be aware that if you use this option you won't be abble to use implicit measures on your model anymore, meanig you cannot drag as column to a chart and make a sum or a count you will need to star using measures for all calculations.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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