I have data at a date level. and have measures like sales, orders, cogs all numerical. I want to create a filter which should have all the measures in a filter. whenever one is selected the table is populated with that measure
If there are multiple columns like sales, orders. Then how do make all these columns as filter. The value in the table should change to selected metric from the filter
Are you saying, for instance, if you select sales you would only see sales in your table?
You can use this with parameters & calculated fields.
Create a parameter called “measure” and then you’ll need to select a default value. You can say sales.
Then create a calculated field called measure.
Then you can use this in a table.