Forum

Notifications
Clear all

Line chart visual is not showing quarter and month values when i drill down.

2 Posts
2 Users
0 Reactions
175 Views
(@kabasa007)
Posts: 1
New Member
Topic starter
 

Hi

 

The values for month and quarter wont display on the "Actual, Budget and Forecast by Year, Quarter and Month" line chart visual i created while trying to recreate this PowerBI dashboard Mynda created in this tutorial How to Build Power BI Reports from Start to Finish.mynda.png

I have attached an image of what i am getting and the PBIX file.

 
Posted : 16/03/2021 1:59 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Ng,

Welcome to our forum. 

You'll notice you only have data for January in your file. In order to draw a line you need at least two months or two quarters or two years of data to join the dots.

I suspect your system uses date format mm/dd/yyyy whereas mine uses dd/mm/yyyy. If so, you need to go to the first Changed Type step in Power Query and delete it. Then right-click the date columns (one by one) and choose 'Change Type' > 'Using Locale...' > select Date for the data type and 'English (Australia)' for the locale.

Mynda

 
Posted : 16/03/2021 9:28 pm
Share: