Forum Discussion
Problems with visualizations Showing up from variables
Hello,
I'm New to power BI. I've uploaded an excel sheet with financial revenue based on parkign activities. The Colomns in the excel sheet are segmented in the correct manner. However, When I want to visualize for example from the QR machines only it won't show bar charts. But if I tick the total then there will be bar charts that show up.
The same goes for when I try different variables like (Cash + POS) Only not including TOTAL. It doesn't show charts. Only when I check the toal does it show.
What am I doing wrong? Looking forward to any feedback. Thanks
4 Replies
Your column charts don't have enough data for rendering. Add the value column to the y axis.
Thanks for your feedback. I have applied your solution by moving some variables to the Y-Axis. I'm finding the same result. There are no visuallizations generating or all the days on the X- Axis are showing as 100% instead of count or as a % of the total. Some are even showing the total on the Y-Axis as being 0.5 or 1.
See attached.
I would appreciate any feedback.
Hi zshubailymakani ,
Could you please share the sample data and the expected visual outputs?
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Best Regards,
Wearsky
Hi zshubailymakani ,
This seems to be a pivot table after processing in Excel.
Could you share sample data and expected output in standard table format?
Best Regards,
Wearsky
