Pie Chart "values"

[Anonymous]

Good morning.  I have a pie chart in my dashboard that is pulling in data from an excel sheet where the "totals" (%) are based upon a formula withing excel.   Power BI pie charts, when placed into values, does not recognize the data in excel since it is a formula and evenly represents the data as equal pie values (distributed as 11% as there are 9 values).  Any thoughts on how to have Power BI read the value return from the excel formula so it can be displayed on the visual?

[Anonymous · Accepted solution]

Thank you.  I ended up editing the data in Power BI and changed it to % percentage and applied without summarizing and that worked.  Thank you! 

[amitchandak]

@Anonymous , Power bi read data from excel as source.

There is an option to merge power bi and excel in app, please explore that

Power bi Excel for P&L , add in app
Curbal
https://www.youtube.com/watch?v=IISYzTaIyu4
Guyinacube
https://www.youtube.com/watch?v=1yJnmZRTNZg