Can the individual series of a pivoted dimension be split between different axes ?

Knowledge Drop

 Last tested: March 31, 2021

No. Each measure goes on one axis. If you have a measure pivoted, all of its pivoted values go on the same axis.

If you want to specify the axis for a particular measure for each pivot, then use filtered measures instead. Create a filtered measure for each possible value (and maybe one more for any unanticipated values). Then you can specify which axis to use for each of your new measures (cite docs).

This content is subject to limited support.                

Version history
Last update:
‎04-05-2021 09:00 AM
Updated by: