Is it possible to switch between 4 option of "show value as" in matrix dynamicaly from visual???

[ddpl]

I want "show value as" (1) No Calculation, (2) Percent of Grand Total, (3) Percent of Column Total, (4) Percent of Row Total of matrix on Visual Pane so that user can switch any of them dynamically.

I'm greatful fpr any suggestion.

[Idrissshatila · Accepted solution]

HEllo @ddpl ,

Yes, this could be done using field parameters.

check it out https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

[Idrissshatila · Accepted solution]

HEllo @ddpl ,

Yes, this could be done using field parameters.

check it out https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

[ddpl]

@Idrissshatila ,

I get the job done but after putting parameter into values and then there is no option for conditional formatting...

what to do...???

[Idrissshatila · Accepted solution]

Hello @ddpl ,

check this https://youtu.be/KOeT9Dsk-xo?si=3EOqmeLnYbjdcJqe

[ddpl]

@Idrissshatila 

Thanks a lot Senior, you made my day.