Posts

Showing posts with the label dynamic slicer selection

Current Month or Current Year or Current Day as a Default Selection

Current Month or Current Year or Current Day as a Default Selection To allow users to always select the current month, year, or day, follow the instructions Dax Example CurrentMonth = IF( 'Calendar Table'[Month] = FORMAT(TODAY(), "mmm"), "CurrentMonth", 'Calendar Table'[Month] ) For the year, simply replace the "Month" column with the "Year" column, and similarly for the day or week, follow the same process. Feel free to ask any questions about Power BI. I am here to help you. Happy Learning! 😊