Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
69 | |
35 | |
21 | |
18 | |
15 |
User | Count |
---|---|
127 | |
32 | |
27 | |
24 | |
22 |