I have a test dataset which has has 39 columns. Index is given below: enter image description here

Sample data is as follows: enter image description here

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.



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.