Dynamically choose the measure based on data in x-axis

[shekhar_shres]

Hi all,

I have two measures:

1. Monthly Growth

2. Quarterly Growth

In my line and clustered quarter, we have sales by quarter which can be drilled down to month level. 

(Note: bar is sales and line is growth)

I want the line to switch from [Quarterly Growth] to [Monthly Growth] based on the drilldown. Is it possible?

I tried If(Selected Value) but I realized that the quarter and month are two different columns in dates table so it is not possible. is there a way I can do the switch?

Thank you in advance.

Cheers

[v-xulin-mstf · Accepted solution]

Hi @shekhar_shres,

Please drag and drop the fields into the matrix and check if the totals for the corresponding quarter are displayed correctly when the hierarchy is month?

Just like:

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[shekhar_shres]

For month part it worked, but for quarter that are midway, it's giving undesirable numbers(using monthly figures)

[TomMartens]

Hey @shekhar_shres ,

not sure if this is what you are looking for, but create a 3rd measure like so:

3rd measure = 
IF(
    HASONEVALUE( 'tablename'[Month Column] )
    , [Monthly Growth]
    , [Quarterly Growth]
)

Use this measure on the chart.

Hopefully, this provides what you are looking for.

Regards,

Tom