Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
4 years ago

Automatically use column according to current month in Power BI

Hello

 

I would like to ask is possible to make that in Power BI visual will be used required columns according to current month and year. For example, today is 8 th month August, So in my visual table I need use column 

So if today is 2022 08 then columns above are used here:

 

And in measures.

 

Need Help

1 Reply

  • Hariharan_R's avatar
    Hariharan_R
    Solution Sage
    4 years ago

    Hi Analitika 

    You can acheive this with "Field Parameters". 

    1. Create a field parameter with all the columns that you want to show in the table visual. Including all the months columns.

    2. Create a grouping as a calculated columns. You need to copy and paste default static columns in the syntax of the field parameter table and group them like YYYY MMM or How you stored the slicer Year and month in the date table.

    3. Join this grouping column with date table column.

     

    Thanks

    Hari

    Did I answer your question? Then please mark my post as the solution.
    If I helped you, click on the Thumbs Up to give Kudos.

    My Blog :: YouTube Channel :: My Linkedin