Scenario: How to use a slicer to show different measures? This article will show you another way to create dynamic charts based on the external tools (Tabular Editor) updated in July 2020. 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 switch measure, only one data type is allowed.
For example, we want to dynamically display the rate of product sales in the current month or product sales.
In the previous method, we usually created a disconnected table as a slicer, and then created a switch measure to show the result.
Sum_sales = SUM('Table'[Sales])
var total_month_sales =
var per_product = [Sum_sales]
Create a disconnected table with the measure name and create a switch measure.