bciCalendar multi view

[AndyTrezise]

I'm using the bciCalendar to view information about current month's data based on two slicers that allow users to select year and month.

I want to create a 2nd / 3rd version of the same visual that show 1 and 2 months ahead.

I first created new columns in my underlying table that computed date + 1 month & date + 2 months ( Date.AddMonths([originaldate],1) ).

So I in essence have 3 columns - originaldate, dateplus1month, dateplus2months

I drop dateplus1month onto my second visual (in place of original date) and dateplus2months onto the third visual.

Problem is, by using the slicer I limit the results to a single month so never return any rows for display in my other two visuals.

I think I somehow need to disconnect all the visuals from the slicers and computer the date seperately - then somehow create 3 new datasets that can be applied to my hree visuals.

Not sure if this is correct or not?

Any help greatly appreciated.

[v-caliao-msft · Accepted solution]

@AndyTrezise,

You could create a another date table, and then delete the realationship between new created table and original table. Then use a measure to check if the date in your condition. Please refer to the link below to see the details.
http://community.powerbi.com/t5/Desktop/Show-data-of-last-months-from-a-particular-month-filtering-w...

Regards,

Charlie Liao