I've always done this before about using slicers to display different measures in graph. Create several measures and create a disconnected table to use as slicer. However, this method has the limitation of data format. Since all measures are encapsulated in a selection measure, only one data type is allowed. This article will show you another way to create dynamic charts based on the external tools (Tabular Editor) updated in July 2020.
Read more...