12 month and 1 month visuals on same page

[Tcurtis]

I am new to PowerBi and need to know how to show two visuals with different date ranges on the same page. I have a slicer on my title page that allows someone to select the start date and end date of the report. On a few of my pages I have visuals for both 12 month (or what ever range they select) that is synced with the main page slicer and I have a pie chart that I want to only show the last month in the date range of the column chart. How do I filter my pie chart to only show the most recent month that was selected in the date slicer on my main page?

Thanks

 

[JustynaMK]

Hi,

Interesting scenario - could you please share some exemplary data? Also, do I understand correctly that if the user selects 12 months (1 Jan 2018 - 1 Jan 2019), do you want to then display some aggregate (sum? max? avg?) for the last month (1 Dec 2018-1 Jan 2019) on your pie chart?
Is your Pie chart data and Date slicer from the same table, or are they two separate tables? If separate, do they have a relationship in a data model?

 

[Tcurtis]

I created a date table in PowerBi and linked it to my data. The Date table is what I use for my slicer and filters for my graphs. I do not know how to load data on the website.
I have my year graph by month and by site. My pie chart is for the last month of the year that is displayed on the 1 year column chart by site. I am counting unique job numbers for each month and each site.

 

[JustynaMK]

Thanks for explaining.

Here's how my two tables are linked in a data model:

I have added a table that always shows data for the selected time range, for 3 sites (A, B, C). On the right-hand side, you will notice a pie chart that always shows the values from the last row of the table.

Here's the DAX measure that I needed to use on my Pie chart, along with some additional comments:

Last Selected = 
    //Slicer - return the last Selected Date
    var vLastDate = 
        MAXX(ALLSELECTED('Date'), 'Date'[Date])
    //Identify the Maximum Date in Table5 that is less or equal selected Date
    var vMaxDate =
        MAXX(FILTER(ALL(Table5[Date]), Table5[Date] <= vLastDate), Table5[Date])
    //Return the Value for the Maximum Date
    var result =
        CALCULATE(MAX(Table5[Value]), Table5[Date] = vMaxDate)
return
    result

I'm hoping this small example will get you started. Let me know if you need any help.