Change tooltip message based on measure being hovered over in a matrix
Hi, I am trying to get my tooltip value to display a custom value for each unique measure in the "Values" field in my Matrix visual. For example, I have the below fields in my visual. When I hover over a value in my matrix, I want a custom message to pop up based on the measure I have hovered over. Example: When I hover over a value associated with the "Calendar Month Settlement" measure below I want it to show "1" and if I hover over a value associated with the "WTI CMA" measure in the matrix I want it to show "2" etc. So I want my custom message to show up based on the measure I am hovering over. Is there a way I can write this in DAX?
Need to pass date value to tooltip but not all visual in tooltip
Hi, This is my first post. I'm working on Tableau to Power BI migration. I have a scenario where we have a line graph and when we hover on any month, it will show a tooltip with full sales trend and value of that sales value for that particular month. I createded the tooltip but if i turn on the tooltip "filter all values", the trend shows only one month of data which I'm hovering. But if if I turn off "Filter all values" Im getting proper trend Data but for that selected month is not populating data. If I keep "Filter all" then I get only hoveringm onth trend and sales on card. If I turn off "Filter All", I get the trend, but the month's sales is aggregated to all months, not the one I'm overing on the line. Requirement is to show the hovering month's sale on the card and show full sales trend. Im new to power bi, please help any solution. Thanks in advance, Regards, RintoConditional formatting tooltip title & tooltip not properly working
Hi, I have 2 pages, a report page and a tooltip page. In the report, there is a table of KPI items whose tooltips are enabled and display the trend chart performance of the KPI items. I have 2022 and 2023 data with unique codes (each year is different). I have a problem, on the report page there is a year slicer, when I select any year, when in the third item of the KPI, the tooltip displays data for the entire year (2022-2023) when it should be displayed only the third item in the selected year. Is there any idea to solve this problem? For the title tooltip, the dax looks like this: RiskTitle = IF(HASONEVALUE(Risk_Event[Code]), FIRSTNONBLANK(Risk_Event[Risk Event], ""), """Please Check on Risk Event below ..""")
Matrix visual tooltip to show values
I have a table of elements such as: Each person can have multiple categories. From this table I have managed to create a matrix like this: In order to achieve this (with help from this forum) I used the following Measure to aggregate the numbers: Measure = if(VALUES(Classification[Classification])=VALUES(Classification_dup[Classification]),0,CALCULATE([People],CALCULATETABLE(SUMMARIZE(VALUES(Data[IdPerson]),Data[IdPerson]),ALL(Classification),USERELATIONSHIP(Data[Classification],Classification_dup[Classification])))) I am now struggling with trying to create a tooltip that shows the Name (or ID) of the people in each cell, i.e. I want to create something that liiks like this: The mock up file is attached below: https://www.dropbox.com/s/i2wrw6zowwjzxs0/Cross%20matrix%20example%20post.pbix?dl=0 I would be very grateful for any help.
Dynamic Date measure for custom tooltip when Drilling up or Expanding
I am creating a custom tooltip for a line chart. Users can Drill up or Expand to the next level in the date hierarchy (Year - Quarter - Month). In the tooltip, I'd like to write a measure to display the Year only when viewing on 'year' level, Year and Quarter only when viewing on 'quarter' level , Year and Quarter and Month name on 'month' level. Or any other alternatives. Currently I'm placing textboxes "Year","Quarter","Month" next to respective card visuals (using SELECTEDVALUE()); but a. it's difficult to align them nicely and b. when you're on the 'year' level, the quarter and month cards are blanks, while the texts "Quarter" & "Month" are still there.
