Forum Discussion

mirfanshahid's avatar
mirfanshahid
New Member
5 years ago
Solved

Data filter on multiple date

Hi all, I have patient data with four different dates 1. PK: FormId, 2. Date Of Collection 3. Received Date 4. Validated Date 5. Added date I have a requirement to show all the four-date data ...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi mirfanshahid 

     

    In Power Query Editor, select all date columns and unpivot them. (I take 3 columns for example.)

     

    In Power BI Desktop, put Attribute column into the slicer. You can change column names per your need.

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

In the Query Editor, rIght click on the first column's heading and select "Unpivot other columns".  Now try to build your desired visual.