The measure used for the custom tooltip can be edited so that it shows blank values for total rows. Please see this response on the Power BI forum community.fabric.microsoft.com/t5/Desktop/Omitting-tooltips-for-totals-and-subtotals/td-p/2363767.

Hello again. I sorta figure out why but couldn't fully explain why. Hope you can help. I made sure my tooltip includes one measure and one field (my previous tooltip didn't include any measure). Dragged the measure field to the tooltip filter, and then it worked. From my observation, seems the measure is the key for this trick to work. Is it correct? Thank you

That is correct. The column measure in the matrix that you want to show tooltips for is the same measure that needs to be added to the tooltip page filters section. This is shown from 0:47 to 0:53 in the video where minimum profit is the column added to the filters section on the tooltip page and minimum profit is the same column in the matrix visual that the tooltip appears for. It needs to be the same measure in both instances for the tooltip to show for that particular measure.

This only works for the matrix visual at the moment

Hi, you can try to overlay transparent card visuals on top of the matrix row headers and add the tooltips to the card visuals. Something similar to what is shown in this video: kzbin.info/www/bejne/oWHGqIaPg72boas

Thanks ✌️

Hi, please see if this video answers your question: kzbin.info/www/bejne/h4XJaniqp8-ohs0

Create a new tab in the Power BI file > go to the visualizations format page > expand the 'Page information' section and turn on the 'Allow use as tooltip' toggle. You can then adjust the size of the page in 'Canvas settings' and create your tooltip visuals as normal. This video shows how to create a tooltip page: kzbin.info/www/bejne/fmPWq2meepp3mck

If you would like to upload multiple files into multiple tables then you can begin the video from 1 minute and 30 seconds and the rest of the process will be the same. If you mean to upload multiple files into the same table then start the video from 1 minute and 30 seconds and when it gets to 2 minutes and 20 seconds, you will see the Destination column on the right side of the pop-up window. Here you can select the table that you would like the data to be uploaded to. You can select the same table for each file but the table needs to be created before you begin importing the data.

Hi, are you working with .xls files? Check that your defined folder name follows the structure with a backward slash before the end quotation and no spaces between the quotation marks and the folder name e.g. Folder = "C:\Users\Username\Documents\Data/"