Forum Discussion
bciCalendar multi view
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.
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-with/m-p/197395Regards,
Charlie Liao
1 Reply
- v-caliao-msftMicrosoft Employee
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-with/m-p/197395Regards,
Charlie Liao