Power BI: define a row as header/title for a table
Sometimes when I load an excel sheet, Power BI doesn’t recognize the header and it defines a new title by itself, something like that:
Excel | Power BI |
In this case, instead to try to figure out what’s wrong, in Power BI, there is way to put it correctly.
- 1. Home -> transform data -> transform data
- 2. Home -> use first row as headers
- 3. Close & Apply
Interesting Topics
-
Be successfully certified ITIL 4 Managing Professional
Study, study and study, I couldn’t be successfully certified without studying it, if you are interested...
-
Be successfully certified ITIL 4 Strategic Leader
With my ITIL 4 Managing Professional certification (ITIL MP) in the pocket, it was time to go for the...
-
Hide visual and change background color based on selection
Some small tricks to customize the background colour of a text box...
-
Stacked and clustered column chart or double stacked column chart
In excel, I use a lot the combination of clustered and stacked chart...