Forum Discussion
Nawalasim8
1 year agoRegular Visitor
How to customize tooltips to show different values for different measures?
Hello, Ive created the following bar chart that shows 2 measures showing current year data and previous year (same period last year using dax). This data is shown against time (month in this case...
MFelix
Super User
1 year agoHi Nawalasim8 ,
For this you would need to do one of two things:
- Add a measure with the calculation of the previous year month to the tooltip option of the visual so you would get 3 values on the tooltip.
- Create a custom tooltip to show what you need
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips
Nawalasim8
1 year agoRegular Visitor
Hello, thanks for the help. While this can be done, is there a way i can customise the tooltip for each bar instead of showing the same measures for both bars in the tooltips? The report tooltip feature also doesnt seem to allow for this
- MFelix1 year ago
Super User
Hi Nawalasim8 ,
You can try to use a field parameter and then a switch measure to do the calculation.
Use the Current value and the previous one for the Field parameter then a measure similar to :
Calculation values = SWITCH (SELECTEDVALUE(Parameter[Parameter Order] ), 0, [CY], [PY])Then add this has your measure.
Create a tooltip page with the parameter in order to get the correct value.