How to create measure and axis based on parameter/slicer selection

[Laocsulak]

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 = 

TPV MoM =

VAR __PREV_MONTH =

 CALCULATE ( SUMX(Sheet1,Sheet1[amount]) , DATEADD ( 'Calendario'[Date], -1, MONTH ) )

RETURN

 IF (

 ISBLANK ( __PREV_MONTH ),

 BLANK (),

 ( SUMX(Sheet1,Sheet1[amount])  ) / __PREV_MONTH - 1

 )

Parameter created to show month or quarter in X axis:

Parameter = {

    ("Periodo", NAMEOF('Calendario'[Periodo]), 0),

    ("Trimestre", NAMEOF('Calendario'[Trimestre]), 1)

}

Dummy example:

https://drive.google.com/drive/folders/1Cssqngz5G645NpiZRjnTQ74oxBYoj6db?usp=sharing

Thanks in advance!

[Anonymous]

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. 

[Laocsulak]

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.

[amitchandak]

@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