Johannesburg Power BI User Group Meeting
For the last event of 2022, we present episode 6 of the Brick-by-Brick series: The Final Destination. Presenting will be James McGillivray from Cobalt Analytics on "Power BI Design for the Aesthetically Challenged." In the BI flash Keamo Matlala will host a discussion on the pros, cons and how-to's of implementing report tooltip pages. Finally, since this is the final event for the year, we'll also be running a few surveys at the end of the session on the experiences from 2022 and how we'll continue to improve the user group for 2023. Agenda: BI News - Siya Zungu Brick-by-Brick Episode 6: The Final Destination - James McGillivray BI Flash: Report tooltip pages - Keamo Matlala As usual, pizza and beverages will be served so please RSVP.
ToolTip Advance - Filter Help
Hi all, I'm working on a Power BI report where I show monthly Gross Sales in a table and would like to display a tooltip chart when hovering over the table rows. The goal of this tooltip is to show the entire year's trend line for Gross Sales, not just the single month that was hovered. What I want: When hovering over a row (e.g., Brand 3), I want the tooltip to show a Bar chart for the full year (e.g., Jan–Dec ). The tooltip should still respect other slicers from the main page: e.g., State but ignore Month Slicer What I’ve Tried: Created a Tooltip Page. Enabled the page as a tooltip and linked it to the table. It works — but only shows a single month (the row context from the table). However, the date context from the hovered row still dominates the chart axis — only one Bar appears instead of the full year. What I Need Help With: How can I structure my tooltip chart (and DAX) to: Ignore just the row-level month/date from the hovered row Still respect the full context of slicers (State etc.) Always show the full year trend on the tooltip chart? File working
DAX measure for report tooltip
Hi, I am new to power BI and facing issues with a conditional tooltip. I have a combined table with all the data I need. (see sample data bellow). And I created a report gruoping the products by code and displaying the min, max and average unit price I want to be able to see the technical specification (could be one value or many) when I hover over the min or max values. I have been testing few dax code to create a measure and use in the tooltip, but I couldn't get it to work. Note that one code can have multiple technical specifications and unit costs, the logic I am using is e a condition combining the code and unit price to display the coresponding technical specifications. bellow is my latest attempt, that generates an error code (MdxScript(Model) (4, 1) Tooltip = VAR SelectedID = SELECTEDVALUE('Combined table'[code]) VAR SelectedValue = SELECTEDVALUE('Combined table'[Eur/Unit]) VAR Resulttable= CALCULATETABLE( 'Combined table', 'Combined table'[code] = SelectedID && 'Combined table'[Eur/Unit] = SelectedValue ) RETURN VALUES('Combined table'[Technical specification]) Thank you in advance Simo
