Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have created a bar chart where X axis is month or quarter based on parameter selection. Also, I have created a measure that shows month over month variation, but I would like that the measure shows quarter over quarter variation when the quarter is selected for X axis parameter. Anyone know how to solve this problem?
Measure created to show month over month variation:
TPV MoM =
Dummy example:
https://drive.google.com/drive/folders/1Cssqngz5G645NpiZRjnTQ74oxBYoj6db?usp=sharing
Thanks in advance!
Hi @Laocsulak ,
Please try to create a measure.
infectionSwitchStatement =
var Infection =
SWITCH (
SELECTEDVALUE('Eje X'[X Axis Fields]),
"Mensual", 'metricas'[TPV MoM],
"Trimestral", 'metricas'[TPV QoQ]
)
return Infection
Please refer to the following document for more information.
The workaround of using the measure as axis in the... - Microsoft Power BI Community
Field Parameters in Power BI - Microsoft Power BI Community
Measure Calculation Using Dynamic Column Names - Microsoft Power BI Community
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the answer, but what I need to see is the percentage variation month over month and quarter over quarter, and this createad measure is not showing any value.
@Laocsulak , Refer How Switch measure in field parameter
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Others
Field Parameters- Conditional Formatting: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf
User | Count |
---|---|
55 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
83 | |
54 | |
39 | |
21 | |
15 |