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.
I created a table in which there are products and the values for them in the selected month, next to the values in the previous month and measure the difference of%. I would like to put a parameter on top of the slicer in which I will put the difference of% months and how I will choose eg 30% will show me the value with a difference of 30% and above
Solved! Go to Solution.
Hi krzysztof,
Modify your measure like below and check if it can meet your requirement:
Diff % Month = VAR result = DIVIDE([Value ACTUAL MONTH],[Value Last Month],0)-1 RETURN IF( result >= (Parametr[Wartość Parametr] / 100), result)
Regards,
Jimmy Tao
Hi krzysztof,
Modify your measure like below and check if it can meet your requirement:
Diff % Month = VAR result = DIVIDE([Value ACTUAL MONTH],[Value Last Month],0)-1 RETURN IF( result >= (Parametr[Wartość Parametr] / 100), result)
Regards,
Jimmy Tao
Hi krzysztof,
Could you please share more details about your requirement and share some sample data?
Regards,
Jimmy Tao
Hi,
I can use parameters to analyze what if but here as You see the parameter is to be used as a filter, will you help me? Maybe You have a different solution
https://drive.google.com/file/d/19Cm7d0qjXHUFEMIUGtGRGxmofwB_-Dbr/view?usp=sharing
I belive you need to create your difference % as a column and not as measure in order to drag it to a slicer 🙂
Do you have an idea how to solve this problem?
I will be grateful for your help
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 |
---|---|
97 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |