Forum Discussion
Change y-axis based on slicer clustered column chart
Hi Janaya1
First you need to make a measure for each one, Right click the table and choose new measure:
Average of Assay A = Average(table[Assay A])Then create a field parameter
Modelling | Field Parameter | Fields
Name your new category and drag in all the measures.
Finally drag your new field into the Y axis, here mine is called Swap Assay
Done!This feature is called field parameters and can be used to swap categories like Day and Person but also KPIs like Assays A - D : https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
Super UserHi Janaya1
First you need to make a measure for each one, Right click the table and choose new measure:
Average of Assay A = Average(table[Assay A])
Then create a field parameter
Modelling | Field Parameter | Fields
Name your new category and drag in all the measures.
Finally drag your new field into the Y axis, here mine is called Swap Assay
Done!
This feature is called field parameters and can be used to swap categories like Day and Person but also KPIs like Assays A - D : https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters