Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dynamic Date Headers

I created a table with dates that updates every week.       I created a straight table where I list all the fields with icons (KPI). You will see the dates are ordered as the OrderID above....
Need Help
Tips and Tricks
Tutorial Requests
MFelix's avatar
MFelix
Icon for Super User rankSuper User
5 years ago

Hi Anonymous ,

 

Is the import of the information in the first format or the second one?

Anonymous's avatar
Anonymous
Not applicable
5 years ago

MFelix 

 

The first format is being used in my report.
  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    5 years ago

    Hi Anonymous ,

     

    I was abble to get a working solution working with unpivot and creating a middle step to get the column names and sort the information in the I also create some measure for condittional formatting be aware that this may needs some changes.

     

    Check PBIX file attach, and experiment with other information wiht different dates.