Get Value of the row instead of the count

[Nish_G]

Hi All,

I have written a query to get data from the Azure analytics view and the data is being displayed correctly in power BI.  It is displaying one row with some value. In the table visualization, count of rows is being displayed. I would like to display the value of each cell, not the count of the rows.

Could someone help me please because I don't know how to show only value of the row of my table visualisation .

Thanks

[Nish_G]

Thanks, it worked.

[PhilipTreacy · Accepted solution]

Hi @Nish_G 

Looks like your data is not set as numeric in the Data Model, so PBI just uses the count of the number of values to display it.

In the Data Tab, select each column and change it to a numeric type like Whole Number 

Remove the values from your pie and re-add, they should add with Sum aggregation

Regards

Phil

[Syndicate_Admin]

Hello, sorry, and what do you do if the values I am using are hours?

[mahoneypat]

In the format options for the pie chart, change this pull down to include one with Category in it.

Regards,

Pat

[amitchandak]

@Nish_G , Make all the columns in table visual as not summarize

[Nish_G]

Thanks for your reply.

I have the filter options you have shown in your image above. How to get that summarise option? I have pie chart for my data and it is showing 1(number of rows). I expect to see the value of the row.

I have only 2 sort options, ascending and descending.