cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Issue with my chart

Dear All,

 

I created a chart in Power BI Desktop. My data source is an excel file, showing the number of attendees for the Teams training by date.

 

1/ In the model view, the dates are in chrono order but when i built my chart the dates are not in chrono order; how to fix the issue please?ChartTraining.PNGModelView.PNG

 

2/ How to display the values on each bar?

 

Thank you very much

 

Katie

3 ACCEPTED SOLUTIONS
Community Champion
Community Champion

@Kat12345 

To have your dates sorted in chronological order, make sure they are formatted as dates. Then you can sort it in any order you need. Make sure your dates column is not sorted by any other column.

Select the column and Choose Date from Data Type, you can also do in Power Query

 

Fowmy_1-1597327847613.png


To enable Data Label, select the chart and Enable Data Label.

 

Fowmy_0-1597327829296.png

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

 

View solution in original post

Community Champion
Community Champion

@Kat12345 

 

You need to go to power query, right click on the date column, select Change Type, select Locale, choose DATE, select English United Kingdom. 

View solution in original post

Community Champion
Community Champion

@Kat12345

That option is not for sharing,

If you wanna share your work with your managers and colleagues, Either you can share the PBIX file with them so they have to install Power BI desktop and open the file, which is not the right and effective way of sharing.

or, the recommended way is to upload your file to Power BI service and share it from there to avail of all the benefits that comes with Power BI Service.

Check out these articles for more info.

https://www.youtube.com/watch?v=pij4gkznI2g&vl=en
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-share-dashboards


________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, Linkedin

View solution in original post

5 REPLIES 5
Community Champion
Community Champion

@Kat12345 

To have your dates sorted in chronological order, make sure they are formatted as dates. Then you can sort it in any order you need. Make sure your dates column is not sorted by any other column.

Select the column and Choose Date from Data Type, you can also do in Power Query

 

Fowmy_1-1597327847613.png


To enable Data Label, select the chart and Enable Data Label.

 

Fowmy_0-1597327829296.png

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

 

View solution in original post

Hi Fowmy,

 

I tried to change the data type from text to Date but Power BI Desktop doesn't allow me, saying that my dates in my excel file are not dates... ? which is not true.

Could you please help me out.

 

ModelViewDate.PNG

ExcelFile.PNG

 

Thank you 🙂

Community Champion
Community Champion

@Kat12345 

 

You need to go to power query, right click on the date column, select Change Type, select Locale, choose DATE, select English United Kingdom. 

View solution in original post

Thank you Fowmy for all your precious advices.

 

I would like to know if I can share all the report pages to my boss, from Power BI Desktop? because I saw a button Manage roles, I created a role but is it possible to share this report now? do we have to share tab by tab?

 

or to share, we really have to publish the report to Power Bi Service?

 

Thanks again

Community Champion
Community Champion

@Kat12345

That option is not for sharing,

If you wanna share your work with your managers and colleagues, Either you can share the PBIX file with them so they have to install Power BI desktop and open the file, which is not the right and effective way of sharing.

or, the recommended way is to upload your file to Power BI service and share it from there to avail of all the benefits that comes with Power BI Service.

Check out these articles for more info.

https://www.youtube.com/watch?v=pij4gkznI2g&vl=en
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-share-dashboards


________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, Linkedin

View solution in original post

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors