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?
Customizing Tooltip on Table
Hi everyone, I want to add a tooltip on my table. Is there any option to make visible the tooltip on only one column (the Change column) other than all columns of my table? I do not want to see the tooltip on all of the cells. Any help would be appreciated. Thanks in advance.
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, Rinto
Dax help for measure on stacked column chart that's filtered
Hi PBI RS Army, I am seeking guidance on something that seems like it should be simple but is proving to be challenging: I have a stacked column chart showing sales of various items of winter apparel by region (N, S, E, W) Some items (like gloves) are sold in all regions (this is completely fabricated sample data). I have two slicers: 1. Category = gloves 2. Region = only East and North (excluding West) I also have a tooltip tab that pops up when hovering over any of the elements of the stacked column chart as shown: The challenge I'm having is getting the measure (sum of sales measure) to reveal the sum of east region + north region (only) on the tooltip which is shown when hovering over either of the East or North region segments of any of the years. My formula for that measure is: sum of sales measure = CALCULATE(SUM(DATA[SALES]), REMOVEFILTERS(DATA[REGION])) Because I have the removefilters(data[region]) in the filters portion of the dax, it includes all three regions (including West). But of course if I remove that removefilters(data[region]) portion from the measure, it'll only show the sum of sales for the region over which I'm hovering. Any guidance appreciated.Creating Customized Legend and Tooltip for Clustered Column Chart
Hi everyone! I hope you can help me with a visualization challenge I'm facing. I have created a clustered column chart to display year-on-year (YoY) inflation based on different cities. The chart shows two columns for each city: one for the current quarter and year's YoY inflation and the other for the YoY inflation from the previous quarter. I have also filtered the data based on selected quarters and years. Now, my question is: How can I customize the legend and the tooltip to dynamically adjust based on the selected filter values? For instance, if I select "Quarter I" and "2019" from the filters, I want the legend to show "QI 2019" for the current quarter and "QIV 2018" for the previous quarter. Similarly, I want the tooltip to display the respective inflation values for the selected quarters. Is there a way to achieve this in Power BI? I would greatly appreciate any insights or solutions you can provide. Here I attached an illustration of my current chart for reference. Thank you in advance for your help! ❤️Tooltip selection with date slicer
Hi everyone, I have a question and I hope some of you can be of assistance. The situation is as follows: I have a report page that show different KPI's (lets say customer satisfaction, sales, budget minus realisation and so on). I use below tooltip to show high/low lights and actions and other visuals. See below for tooltip. The question is as follows: When i keep my history of different tooltips info over different months (so: different tooltip pages for each month), can I use a slicer to select these different tooltip pages? Lets say first I show the KPI for february with the tooltip for february aswell. Next, I use a slicer to select january, and now i want the KPI to show january and the tooltip for january aswell. Thanks in advance.
