The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
User | Count |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
36 | |
14 | |
12 | |
7 | |
7 |