The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Is there a visual that allows me to do the following ?:
- I have 3 time measures that are calculated in minutes and I am plotting them in a bar chart grouped by region.
- I need to do the same but instead of putting the value in minutes on the label, I want to show it in days, hours and minutes.
- I have created 3 additional measures to transform those minutes into days, hours and minutes to be able to show them, but I cannot find a visual that allows me to do the image.
Does anyone know a visual that can do that?
Hi, @Anonymous
After testing, the time format really cannot be applied to the Stacked bar chart view.
Unfortunately, this is by design. power BI is now unable to achieve what you need . You can submit an idea for it at https://ideas.powerbi.com/forums and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous,
The stacked bar chart only accepts Numbers as data - it doesn't recognize your text (d, h, m) measure as a number.
My suggestion is to display your Measure as a Decimal Number (i.e 1.5 days).
You should then be able to add your Day Text Measure in the Tooltip field, so when the User hovers over - they will see the text you want them to see.
I realize it's not ideal, but perhaps will serve as a short term fix.