Forum Discussion
Chart and tooltip feasibility
I have a power bi line chart with year and value , i want to show the graph ordered by value , defaultly it is getting ordered by year , and the tooltip should show the value descendingly with value
Hi Linu
Thank you for reaching out to the Microsoft Fabric community forum.
Power BI does not expose line chart legend colors to DAX, conditional formatting, or report page tooltips. Because of this, a custom tooltip (table/matrix) cannot automatically inherit or stay in sync with the line chart colors, especially when new years are added.
Also, native tooltips cannot be sorted, while report page tooltips lose the built-in colored line indicators. This makes it difficult to achieve all requirements together using native capabilities.
As of now, you can try using a custom tooltip along with manual color logic (via DAX or a mapping approach), but fully dynamic color synchronization with the line chart is not supported.
If you have any further questions, feel free to reach out and we'll be glad to assist.
Regards,
Microsoft Fabric Community Support Team.
7 Replies
The native tooltip cannot be sorted, it renders in whatever order the data model returns. The correct approach is a custom tooltip page:
Step 1) Create a new report page → Format page → set Page type to Tooltip
Step 2) Add a bar chart or table visual to that page, with your years/categories on the axis and value as the measure, sort it descending by value
Step 3) Go back to your line chart → Format visual → Tooltips → Type: Report page → Page: [your tooltip page]
Yes i have tried that able to get the data in table format or matrix format but that fails in creating color lines as it comes in line chart tooltip .
To add lines to the table visual you can create a measure like this
Line = "───"And use conditional formatting for fonts to apply color to this line, this way you can achive your desired result
Connect on LinkedIn
read my blogs here: techietips.co.in
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
Okay , i got the concept but can we handle future years with conditioanl formatting as every year should show different colored line ?
Hi Linu
Thank you for reaching out to the Microsoft Fabric community forum.
Power BI does not expose line chart legend colors to DAX, conditional formatting, or report page tooltips. Because of this, a custom tooltip (table/matrix) cannot automatically inherit or stay in sync with the line chart colors, especially when new years are added.
Also, native tooltips cannot be sorted, while report page tooltips lose the built-in colored line indicators. This makes it difficult to achieve all requirements together using native capabilities.
As of now, you can try using a custom tooltip along with manual color logic (via DAX or a mapping approach), but fully dynamic color synchronization with the line chart is not supported.
If you have any further questions, feel free to reach out and we'll be glad to assist.
Regards,
Microsoft Fabric Community Support Team.
Hi Linu
I wanted to check if you’ve had a chance to review the information provided. If you have any further questions, please let us know. Has your issue been resolved? If not, please share more details so we can assist you further.
Thank You.
Hi Linu
We have not received a response from you regarding the query and were following up to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank You.
