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 I have a data table that has transactions for a product sold telling the amount of net value, net qty & net weight which corresponds practically to Sales revenue, packets sold & KG product sold. I want to create a slicer that would adjust all the visuals to which ever unit i select ($$, EA or KG). Can someone advise if that is possible?
Solved! Go to Solution.
This might take some time as you would have to adjust each of the measures that feed into your visualizations.
I would start with creating a parameter table and assigning an arbitrary numeric value to each display type you'd like. For example:
Display | Value
$$ 1
EA 2
KG 3
Then create a measure that returns the value, such as the following:
DisplayValue := Max(ParameterTable[Value). Then place the "Display" column as a slicer, allowing users to select any of the displays. Their input will return a value that you can then use to adjust measures.
Say you want to show the sum of each of those. You can write a measure such as this.
Switch(
[DisplayValue],
1, sum(Sales[Net Value],
2, sum(Sales[Net Qty],
3, sum(Sales[NetWeight[Kg])
)
Obviously you would have to tailor this to each of your existing measures, but the general idea stands. Good luck!
This might take some time as you would have to adjust each of the measures that feed into your visualizations.
I would start with creating a parameter table and assigning an arbitrary numeric value to each display type you'd like. For example:
Display | Value
$$ 1
EA 2
KG 3
Then create a measure that returns the value, such as the following:
DisplayValue := Max(ParameterTable[Value). Then place the "Display" column as a slicer, allowing users to select any of the displays. Their input will return a value that you can then use to adjust measures.
Say you want to show the sum of each of those. You can write a measure such as this.
Switch(
[DisplayValue],
1, sum(Sales[Net Value],
2, sum(Sales[Net Qty],
3, sum(Sales[NetWeight[Kg])
)
Obviously you would have to tailor this to each of your existing measures, but the general idea stands. Good luck!
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 |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |