hi, please suggest, how do i sort this excel data in power bi. i want to populate the no.of drawings under visualization, drawings,headquaters building etc,
excel contains merged rows.
Hi @anandistamsetty,
You should modify the spreadsheet in Excel before importing into PowerBI.
It should always have columns. The blue rows can be a column on the side.
Something like this:
thanks for reply , great