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

[pmaurizi]

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!

[MFelix · Accepted solution]

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.