Two Dates, One Column

[caseylide]

Hi,

Here is a simple reresentative example of the capability I need...

Consider a data source with two dates from Azure Devops - Created Date, and Changed Date. I have a table of work items, and each item has both date colums populated. I want to have one column that displays either the Created Date or the Changed Date, based on user input. In other words, something akin to a "Date Type" selection that the user can make to change what's displayed in the date column when using a Power BI dashboard. I've been taking this approach in Tableau for at least five years now, but I can not find its equal in Power BI.

Can anyone help with tips, examples, or solutions?

Thanks!

[caseylide]

Thanks Tamerj1!!! Yes, I was just looking over this video when i saw your post. This is not available in my desktop instance so I think I must have to update my version. I'll give it a shot!

[tamerj1]

@caseylide 

Yes a new version is available now. Not sure if anything to do with the type of your license. 

[caseylide]

Hi. I tried to update to a newer Power BI version but I still don't have the "fields" option for parameters. Do you know which version supports this new feature for parameters? 

My current version is Version: 2.106.883.0 64-bit (June 2022), and it only seems to be supporting the legacy "numeric" parameters capability.

[caseylide]

Actually it does work now. I just had to enable it in the Preview Features options, as stated in the Description under the video. Thanks for the link!

[tamerj1 · Accepted solution]

Hi @caseylide 

you can use field parameter 

https://youtu.be/TufnsAxJsjs