Some columns are omitted due to privacy concerns. The colored cells in the index belong to one type. I wanna create a custom category so I can create a bar chart or something which can show number of days against the alias of the column. I am not sure how to do it in Power BI.
Secondly I have same column names but different data for the same locations. Is there a way to manipulate the data so I can make a comparison graph on Power BI.
Thanks in advance.