[beginner] need help on how to import an excel correctly

[Vetex_steven]

Hello,

I'm trying to display 2 tables from an excel onto a dashboard.

Table 1 needs to be visualized on a Bar Chart and table 2 needs to be visualized on a Gauge.

Importing the tables from excel is no problem, but visualizing is. I do not get the expected result.

Is there someone who could help me here. The tables are very easy, so I think the problem is how I formatted the tables in excel.

thanks in advance

Steven

[Greg_Deckler · Accepted solution]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

That being said, you probably want to pivot/unpivot those tables.