Tooltip visual ignoring page slicer

[arimoldi]

Hi,

I have a page with a slicer based on quarters and I want to add a tooltip on a table in this page to show a trend over quarters, but if I use the date field on X axis it shows just the filtered date.

I tried to create a measure to have the list of quarters ingoring the slicer:

date trend = CALCULATE(DISTINCT(Tab[quarter]),ALL(Tab[quarter]))

but when I use it in the visual on X axis I get this error:

Any suggestion?

Thanks,

Andrea

[Anonymous]

Hi @arimoldi 

It appears that you are trying to create a measure that will display all quarters on the X-axis of the visual object regardless of the slicer selection.

The error encountered in the screenshot may be due to the fact that the visual object does not accept the measure as a valid field for the x-axis, and you may need to put columns in the x-axis instead of the measure.

To achieve the desired result, try creating a new table containing a list of all quarters and use this new table as the axis for the visual object. This way, the visual object will not be affected by the slicer that filters the main table.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.