Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
it seems like there are some exciting updates / features that allows us now to easily switch visuals from a unit to a dollar display etc.
In my scenario, I have a data model with a single transactional table, that contains for each sales order 4 different columns with values values in units and 1 column with the individual costs per unit for each order:
Order | Value 1 | Value 2 | Value 3 | Value 4 | $ |
1 | 10 | 15 | 5 | 60 | 5 |
THen I have a matrix visual in the report the displays these units for each department as a sum.
Now I would like to add a slicer to select Units or Dollars to display the values in units or units * $.
How would you do that?
Any thoughts on that?
Hello @joshua1990 ,
so, you create a new column to calculate the values in another currency, the make a field parameter that has the first currency value column and the new column.
then in the matrix you put the value of the field parameter and you'll a slicer that has the two columns currencies to switch with and the values would easily switched between the two columns.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
@Idrissshatila Thanks. But as I mentioned, there are 4 columns with units. So the field parameter would have 8 columns in the end, right? I don't want to select the columns in the end, I would like to switch the values.
Hello @joshua1990 ,
You could do that using field parameters ( same as calculated groups), I think its a best option.
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 👍
Proud to be a Super User! | |
@Idrissshatila Thanks. Could you please explain the total approach? Calculated columns for both Units and Dollar? Add these columns as a Field Parameter then? How can I easily switch then from dollars to units all at once?
If i understood your request correctly the below tutorial should be helpful in terms of selecting which column to display in your visual.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
105 | |
79 | |
69 | |
62 |
User | Count |
---|---|
142 | |
105 | |
103 | |
85 | |
70 |