Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi Everyone,
I have a financial report I've created and within it, I show some key headline numbers. One of those is the bank balance as at a given month of a year. There are slicers within the report so a user can choose the financial year and then the relevant month and then the report will surface up the relevant info. It's working well, however I've decided I want to add a tool tip graph so that when you hover over the bank balance it shows the net cash flow movements for the relevant financial year. This is where my problem starts.
You see, if I select a month in the "Select Month" slicer, I lose all the months in the Net Cash Flow tool tip and this shows:
What I want to happen is for the tool tip to show ALL months within the Financial Year(s) selected and ignore the "Select Month" slicer whilst at the same time, have the "Bank Balance" card react to the "Select Month" Slicer i.e. the tool tip should look like the below, but it only gives this view if I de-select the "Select Month" slicer which is not how I want it to react
The dax formulas used are:
Bank Balance = CALCULATE([Net Cash Flow],
Net Cash Flow = CALCULATE(
Solved! Go to Solution.
Managed to solve this myself by putting a blank measure inside a Card visualisation then turning the card background off so it was transparent. I then placed the Net Cash Flow measure inside the tool tip of the blank card and turned off the interaction with the blank card in relation to the "Select Month" slicer. Works perfectly.
I'd love to know the dax formula that would give me what I want though.
Managed to solve this myself by putting a blank measure inside a Card visualisation then turning the card background off so it was transparent. I then placed the Net Cash Flow measure inside the tool tip of the blank card and turned off the interaction with the blank card in relation to the "Select Month" slicer. Works perfectly.
I'd love to know the dax formula that would give me what I want though.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
11 | |
10 | |
10 | |
9 |
User | Count |
---|---|
18 | |
13 | |
12 | |
11 | |
8 |