Forum Discussion
Customize Tooltip for Stacked Column Chart
Hi rsbin ,
We understand your requirement, but unfortunately Power BI cannot replace EquipIDDuration with another measure called EquipID_Formatted.
Because the “hh:mm:ss” format is a text type and when you put a text type to Values, it just count it.
So we just can create a hh:mm:ss column and add it to tooltip.
hh:mm:ss =
INT('Table'[time] / 3600) & ":" &
RIGHT("0" & INT(('Table'[time] - INT('Table'[time]/ 3600) * 3600) / 60), 2) & ":" &
RIGHT("0" & MOD('Table'[time], 3600), 2)
The result like this,
If you have any question, please kindly ask here and we will try to resolve it.
BTW, pbix as attached.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Good Morning v-zhenbw-msft
Thank you for the response. I examined your pbix file to see how you set this up. I see you created a table so that the formatted value changes for each value in the column. I am using Measures for all of my calculations.
These Measures, when brought into the stacked column chart are filtered by several slicers on the page. I can slice by Date, Facility, and other variables.
I do not know how I would convert these Measures into a "table" as you have done and still keep all of the contextual filters.
If you have any further advice or suggestions, I would be most appreciative.
Again, thank you for taking the time to respond.
Kindest regards,
Hi rsbin ,
You can replace the hh:mm:ss column with this measure and put the measure to Tooltips. But you cannot put this measure to Values, because it is text type.
EquipID_Formatted = INT ( [EquipIDDuration] / 3600 ) & ":" & RIGHT ( "0" & INT ( ( [EquipIDDuration] - INT ( [EquipIDDuration] / 3600 ) * 3600 ) / 60 ), 2 ) & ":" & RIGHT ( "0" & MOD ( [EquipIDDuration], 3600 ), 2 )The result like this,
If you have any question, please kindly ask here and we will try to resolve it.
BTW, pbix as attached.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
