Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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!
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!
@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
User | Count |
---|---|
93 | |
83 | |
77 | |
73 | |
66 |
User | Count |
---|---|
115 | |
104 | |
93 | |
64 | |
61 |