Forum Discussion

caseylide's avatar
caseylide
Frequent Visitor
4 years ago
Solved

Two Dates, One Column

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!

Need Help

5 Replies

  • caseylide's avatar
    caseylide
    Frequent Visitor
    4 years ago

    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's avatar
      tamerj1
      Community Champion
      4 years ago

      caseylide 

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

      • caseylide's avatar
        caseylide
        Frequent Visitor
        4 years ago

        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.