Switch in Matrix between Dollar and Units (2 different columns)

[joshua1990]

Hi experts!

I have a table that stores for each article the sales value, the price and the sales value x price:

Article	Sales	Price	Sales * Price
A	500	$5	$2500
B	600	$6	$3600

THen I have a matrix visualization that shows me for each article the Sales as a Whole Number.

Now I would like to create a slicer on top of the report to switch to the $ values.

How would you to that?

Switch 1

Article	Sales
A	500
B	600

Switch 2

Article	$Sales
A	$2500
B	$3600

How would you do that? Is it possible without bookmarks?

[Idrissshatila]

Hello @joshua1990 ,

Yes, this could be acheived using field parameters. You could group the two columns and switvh between then using a slicer.

check this for instructions https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin