Only to show this month dates and last month dates in a visual coming from field parameter

[uj91]

Below is the field parameter :

Toggle Summary_CC = {

    ("This Month", NAMEOF('Reporting.CrossChannel'[This Month Impressions]), 0),

    ("Last Month", NAMEOF('Reporting.CrossChannel'[Last Month Impressions]), 1),

    ("YTD", NAMEOF('Reporting.CrossChannel'[YTD Impressions]), 2)

}

I need to show only this month dates in the visual when this month is selected in the filter and same for last month and YTD. As of now it is also showing all the historiccal dates. 

In the above visual only dates from 1st November till today needs to be shown in the visual. Same to be done for last month and YTD. 

Any suggestions ? 

[uj91]

Hi @danextian , this month means current month , 1st november till todays date. Last month will show all dates from last month 1st october to 31 st october and YTD is from Jan 1 till today date. Some smart way needs to be found so that those historical dates dont show up in the visual only the ones picking from the filter (This month , last month and YTD) 


This month = 

CALCULATE(

    [Total Impressions_CC],

    DATESMTD('Calendar'[Date])

)

last month = 

CALCULATE(

    [Total Impressions_CC],

    DATESMTD(

        DATEADD('Calendar'[Date], +1, MONTH)

    )

)

YTD = 

CALCULATE(

    [Total Impressions_CC],

    DATESYTD('Calendar'[Date])

)

[Jihwan_Kim]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

I tried to create a sample pbix file like below.

[uj91]

This is working but what if we need to get a dimension into the legend. Can the formula be updated for a category ? For now when i am getting a category field to the legend its breaking. 

Any sugesstions ? 

[Jihwan_Kim]

Hi,

Please share your sample pbix file, and then I can try to look into it.

Thank you.

[danextian]

Hi @uj91 

What is your definition of this month? What are the formulas in your field parameters. Also, please provide a workable sample data (not an image), your expected result from the same sample data and your reasoning behind. You may post a link to Excel or a sanitized copy of your PBIX stored in the cloud.