Forum Discussion

TrulsB's avatar
TrulsB
Frequent Visitor
6 years ago

Show all items in a table

I have connected my Power BI Desktop to a sharepoint  list and a MS Excel table. In the Excel table,

 

In the Excel table, i have the records:

Manufacturer (heading)

Honda

Honda

Toyota

Volvo

 

In Power Bi i display this in a  "table", and i need only to show the Manufacturer, but when i display only the manufacturer, i see only 3 records, not all 4 records. 

Honda

Toyota

Volvo  

 

What do i have to change to view all records in the table, and ignore that the Manufacurer name are identical?

 

 

 

Need Help

2 Replies

  • rajulshah's avatar
    rajulshah
    Icon for Resident Rockstar rankResident Rockstar
    6 years ago

    Hello TrulsB ,

     

    You need to have different names in the column or create an index column and then load into Power BI.

    Please let me know if this doesn't help.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI TrulsB ,

    If you are work on table visual, you can right-click on the visual field and choose 'don't summary' to force display all records or add other category fields to expand summarized records.
    In addition, If you are work on graph charts(e.g. bar, column chart) and use these fields on-axis, it will auto summarize records and only display distinct records.

    Regards,

    XIaoxin Sheng