Forum Discussion
Helper IIParameter controlled visual and filtering the tooltip
Helper IIThank you for this v-ssriganesh Unfortunately, the requirements you followed are not quite correct. It should be
- The tooltip respects the Year, but ignores the Quarter context when present
- It always shows the full breakdown of Completed and Active Statuses regardless of which segment is hovered
The tooltip should look like this:
That change was easy enough to accomplish. So, while it does at least give me the full breakdown, I still have the issue where hovering over a segment in the Quarter view produces
instead of
Community SupportHello jjustjjo,
Thank you for your clarification.
I used a disconnected Quarter table along with TREATAS():
- Created a separate table:
Quarter Table = DISTINCT(CER_Data[Quarter])- Used this table in the tooltip matrix (Rows)
- Updated measures:
Active Count =
CALCULATE(
[Count CERs Base],
CER_Data[Active-Completed] = "Active",
REMOVEFILTERS(CER_Data[Quarter]),
TREATAS(
VALUES('Quarter Table'[Quarter]),
CER_Data[Quarter]
)
)
Completed Count =
CALCULATE(
[Count CERs Base],
CER_Data[Active-Completed] = "Completed",
REMOVEFILTERS(CER_Data[Quarter]),
TREATAS(
VALUES('Quarter Table'[Quarter]),
CER_Data[Quarter]
)
)The disconnected table prevents the hover from filtering Quarter and TREATAS() reapplies the correct row-level context. This allows showing full breakdown while ignoring the hovered segment.
For your reference, I have attached a sample .pbix file demonstrating this setup and behavior.
Best regards,
Ganesh Singamshetty
- jjustjjo
v-ssriganesh Thank you. I'll give that a whirl on Monday.