Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a matrix with 5 rows (Region -> Market -> Branch -> Rep -> Sales Order), and 2 values (Total Pipeline & Proposed In-Month).
I've created a tooltip that shows the breakdown of Total Pipeline by Sales-Stage. This works fine for the Total Pipeline value, however, the In-month value returns the Total Pipeline values, due to the setup of the tooltip. I can reverse the tooltip value, but then the Total Pipeline value would show the In-Month value.
Is there a way to setup my tooltip's graph to show a different value, depending on which value I'm hovering over?
Thanks in advance!
Sorry, not following this. Are you using a tooltip page, let's start there.
Yes, sorry, didn't realize my screenshots didn't load...
Yes, TT page, with a donut chart. The chart is set to show the sales-stage in it's legend, and Total Pipeline in it's value.
Does that help to clarify?
Hi @Anonymous ,
Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive for Business and share the link here.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |