Forum Discussion

haykp's avatar
haykp
Helper I
3 years ago

How not to use Count option for plotting

Dear Community,

 

Some freshman quesiton..

I have simple table with test-case name and Run status - Pass or Fail. 

And I want to plot it in Pie chart.

For some reason the Power Bi makes Count of it, which I do not understand why and how to prevent of doing that.

This is my table:

IndexNameStatusDuration (sec.)Top Files

1/ra150_dig_tests/sanity_example_testpassed77 
2/ra150_dig_tests/sanity_spi_testfailed68 
3/ra150_dig_tests/sanity_jtag_testpassed79 
4/ra150_dig_tests/sanity_psi_testpassed61 
5/ra150_dig_tests/sanity_bootloader_testfailed91 
6/ra150_dig_tests/sanity_outframe_spi_testpassed73 

 

And this is what powerbi plots:

 

 

I did some google and has setup the Dont summarize option for the data, but it does not help

 

 

Thanks

Hayk

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    haykp , Pie needs legends and values. The values will always be aggregated. You can additionally add details.

     

    So if you are adding column values if will take count or sum depending on data type, you can change that to other suitable options