Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Following are my column headers:
I have a parameter which dynamically changes everyday, i want my dashboard to use a different column based on the parameter value. That is, if my parameter has 13/02/2023, i want my powerBI to filter the 13/02/2023 column from the above table.
If it helps, the parameter updates to today's date everyday, so basically i want my PowerBI to filter today's column, everyday. If this can be done without the need for a parameter, I would be happy to see that solution as well.
Is this possible?
Thanks in advance!
Solved! Go to Solution.
Rather than unpivot, I transposed the data to have the dates in rows, and filtered the row based on the parameter
Column1 is the transposed date column, MaxDate is my parameter.
I did another transpose again, to get it back as a column
Rather than unpivot, I transposed the data to have the dates in rows, and filtered the row based on the parameter
Column1 is the transposed date column, MaxDate is my parameter.
I did another transpose again, to get it back as a column
@EashwarBalaji , If this is your table structure, you should try to unpivot the dates in power query.
https://radacad.com/pivot-and-unpivot-with-power-bi
Then you can have a column like this in table of date table to filter
Is Today = if('Date'[Date]=TODAY(),"Today",[Date]&"")
Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |