Problems with visualizations Showing up from variables

[zshubailymakani]

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

[Anonymous]

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

[Anonymous]

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-...

Best Regards,

Wearsky

[lbendlin]

Your column charts don't have enough data for rendering.  Add the value column to the y axis.

[zshubailymakani]

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.