Urgent! on select weekending date from slicer, all weekending dates of that quarter should listed.

[HKIndia]

Hi champs!

Please help on below query if someone has done this kind of requirement or if it is possible in Power BI.

 I have slicer with weekending dates, now I want to create stacked column chart with all weekending dates of quarter of the selected date. Basically, If i select any weekending date from slicer than all weekending dates of that quarter should be displayed.

Report PBIX link

https://www.dropbox.com/s/1a66x5de00l6g8g/All%20Weekedning%20dates%20of%20selected%20date%20quarter%... 

[ThxAlot]

Why don't you make a slicer with quarter? Then it's way much easier to filter out undesired dates.

[HKIndia]

@ThxAlot  Yeah I know that but My other visuals are working on weekending dates and i want to add one more stacked column chart controlled by existing weekending date slicer.

I have created 2 measures which provides start date of quarter and end date of quarter based on weekending date selected in slicer however, I am not able to use them while creating new table in calendar formula where we can list down selected weekending date quarter dates in one column than we can create another column weekdningQtr from Qtrdate column than we can use that weekending date column in stacked column chart in x-axis.

can someone help can we use measures in calendar formula to list down all dates based on start and end date measures. Thanks in advance!

[ThxAlot]

Easy logic but verbose syntax,

Weekendings in Qtr = 
CONCATENATEX(
    FILTER(
        DATESBETWEEN(
            CalendarDate[Date],
            STARTOFQUARTER( CalendarDate[Date] ),
            ENDOFQUARTER( CalendarDate[Date] )
        ),
        WEEKDAY( CalendarDate[Date], 2 ) = 7
    ),
    CalendarDate[Date],
    " | "
)

[HKIndia]

@ThxAlot  This is providing in measure but i need these dates in column of new table. Thanks for trying

[HKIndia]

@ThxAlot  Thanks for your reply, I will check to imlement it, As i can see you have not selected weekending date slicer instead of Calendar date