Forum Discussion
Solved
Data structure for multiple lists
I am very new to Power BI and currently, I am trying to make an analysis of an extensive list of standards as a part of an organizational audit that I have conducted with my team. I work in healt...
Hi qharley ,
Based on my understanding of your requirements, you can try this:
1. In Power Query Editor, unpivot your columns: Amb_clinic1 to Amb_clinic5.
2. In Power BI Desktop, you can use Standard as a slicer to filter Met or Unmet.
3. In Power BI Desktop, you can set background color of Priority 1 & 2.
Hope this could help you. For more details, please check the attached PBIX file.
Reference: https://docs.microsoft.com/en-us/power-bi/desktop-what-is-desktop.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Well, you almost certainly want to unpivot your Amb_clinic# columns.