Month bar charts should dynamically changes as per selection done for QTD/YTD/MTD

[Anonymous]

Hello ,

I have a scenario where i need to change my monthly bar chart as per QTD/YTD/MTD.

So if i select QTD and only current quarter month bar should appear, If i select MTD then only current MOnth bar and for YTD i should be having complete month bars.

Is there any workaround for this.

Thanks!!

[Anonymous]

Hi @Anonymous ,

Sorry to disturb you....

But did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

Best Regards,
Eyelyn Qin

[Anonymous]

Hi @Anonymous ,

According to my understand, you want to dynamically display the value based on “MTD”,”QTD”and “YTD”, right?

I did it in two ways.

Firstly, create a table for X-axis and for Slicer ,too(values set as MTD,QTD,YTD )

Method1:

sum value =
VAR _MTD =
    CALCULATE (
        SUM ( 'DateTable'[Cost] ),
        FILTER (
            'DateTable',
            DATEDIFF (
                'DateTable'[Date],
                CALCULATE ( MAX ( 'DateTable'[Date] ), ALL ( DateTable ) ),
                MONTH
            ) = 0
        )
    )
VAR _QTD =
    CALCULATE (
        SUM ( 'DateTable'[Cost] ),
        FILTER (
            'DateTable',
            DATEDIFF (
                'DateTable'[Date],
                CALCULATE ( MAX ( 'DateTable'[Date] ), ALL ( DateTable ) ),
                QUARTER
            ) = 0
        )
    )
VAR _YTD =
    CALCULATE (
        SUM ( 'DateTable'[Cost] ),
        FILTER (
            'DateTable',
            DATEDIFF (
                'DateTable'[Date],
                CALCULATE ( MAX ( 'DateTable'[Date] ), ALL ( DateTable ) ),
                YEAR
            ) = 0
        )
    )
RETURN
SWITCH ( SELECTEDVALUE ( ForX[Cate] ), "MTD", _MTD, "QTD", _QTD, "YTD", _YTD )

Method2:

Measure =
VAR _max =
    CALCULATE ( MAX ( 'DateTable'[Date] ), ALL ( DateTable ) )
VAR _MTDFlag =
    IF ( DATEDIFF ( MAX ( 'DateTable'[Date] ), _max, MONTH ) = 0, "MTD", BLANK () )
VAR _QTDFlag =
    IF (
        DATEDIFF ( MAX ( 'DateTable'[Date] ), _max, QUARTER ) = 0,
        "QTD",
        BLANK ()
    )
VAR _YTDFlag =
    IF ( DATEDIFF ( MAX ( 'DateTable'[Date] ), _max, YEAR ) = 0, "YTD", BLANK () )
VAR _finalFlag = _MTDFlag & "-" & _QTDFlag & "-" & _YTDFlag
VAR _sele =
    SELECTEDVALUE ( ForX[Cate] )
RETURN
IF ( CONTAINSSTRING ( _finalFlag, _sele ), 1, 0 )

Did I answer your question ? Please mark my reply as solution. Thank you very much.

If not, please upload some insensitive data samples and expected output.

Best Regards,

Eyelyn Qin

[amitchandak]

@Anonymous , I think you need a measure slicer.

https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern

[Greg_Deckler]

@Anonymous This shows one way of doing it: https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-EVERYTHING-measures-axis-legend-titles-chart-types/m-p/1027881#M444