Dynamic multiple date columns with day, month & Year change in slicer selection

[Rama_k]

I have 3 date columns.

I need to show day , month , quarter & year wise total sales in silcer selection.

if choose month in slicer data should change with respect to across date columns

[Anonymous · Accepted solution]

Hi @Rama_k ,

You can create a slicer in Power BI that allows you to select the day, month, quarter, or year and displays the total sales for the selected period. Here are the steps to do so:

Create a new table in the data model that contains the date columns and the sales column.

Create a new measure for each period you want to display (day, month, quarter, year) that calculates the total sales for that period.

Total Sales by Month =
CALCULATE (
    SUM ( Sales[Sales] ),
    DATESYTD ( Dates[Date] ),
    VALUES ( Dates[Month] )
)
​

Create a new column in the table that combines the date columns into a single date column.

Create a new slicer that allows you to select the period you want to display (day, month, quarter, year).

Create a new visual that displays the total sales for the selected period.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.