Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Navneet_NVNY
Regular Visitor

Need to build a Calendar with "things to do"

I need to build this calendar that does not have any values, but has the list of things I need to do each date. I am unable to generate a visual as my data contains just dates, month and things to do. Can you help me if this is possible to be done. Will attach the screednshots here. The No "1" just signifies this task i need to do.My raw dataMy raw dataThe power BI visual I generatedThe power BI visual I generated

3 ACCEPTED SOLUTIONS
MFelix
Super User
Super User

Hi @Navneet_NVNY ,

 

What is the visualization you are using? I was abvble to do it with  Calendar visual by MAQ Software, but there are other on the store.

MFelix_0-1674639426585.png

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

This are the selections

MFelix_0-1674641302773.png

 

I also changed the colours of the activities


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

Hi @Navneet_NVNY ,

 

The sorting is based on alphabeticle order.

 

If you have a month number column (if not you need to create one) you can sort the month name by the column:

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column?tabs=powerbi-deskto...


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

8 REPLIES 8
Navneet_NVNY
Regular Visitor

I have another query. When I place the month slicer, it does not sort as Jan to dec. Rather it sorts alphabetically. any particular reason why?Month.PNG

Hi @Navneet_NVNY ,

 

The sorting is based on alphabeticle order.

 

If you have a month number column (if not you need to create one) you can sort the month name by the column:

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column?tabs=powerbi-deskto...


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Genius!!! Thank you Felix. Worked like a charm... Keep doing the amazing work. 

Thank you for your words. 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Anonymous
Not applicable

There are plenty of custom visuals which this works in. Which one are u using?

MFelix
Super User
Super User

Hi @Navneet_NVNY ,

 

What is the visualization you are using? I was abvble to do it with  Calendar visual by MAQ Software, but there are other on the store.

MFelix_0-1674639426585.png

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Can you share me your "visual" selections that you used. 

This are the selections

MFelix_0-1674641302773.png

 

I also changed the colours of the activities


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors