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
Apple08
Helper IV
Helper IV

To show all legend for a pie chart

Hi All

 

I have a pie chart to show the value of a survey form.  Users can select options from a dropdown list.  There are five options for users to choose e.g. A,B,C,D,E.  Therefore the project field for different months are varied, e.g. Jan-24 with projects A, B, C, Feb-24 with B, C, D, Mar-24 with A,B,C,D,E.  

 

I have a pie chart to show the number of projects for different month.  Is there a way I can keep the legend always showing a full list of five options in the legend no matter there are no values for the projects.  I have tried to right click the field to select 'show items with no data' however it doesn't work.  If user select the month Feb-24 the legend still only shows BCD instead of ABCDE.

 

Please could anyone help.  Many thanks.

1 ACCEPTED SOLUTION
qqqqqwwwweeerrr
Super User
Super User

Hi @Apple08 

 

if my understanding is correct, you want lenges irrespective of filters. i treid to do similar thing hope this will help you also. 

Step 1: Create a table with distinct value for category (A, b... etc), 

Table = DISTINCT(Piechart[Category])
Step 2: join both the table: 
qqqqqwwwweeerrr_0-1712918736156.png

After thet use category in pie chart 

qqqqqwwwweeerrr_1-1712918780815.pngqqqqqwwwweeerrr_2-1712918804839.png

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: https://www.youtube.com/@letssolveproblem

Regards



View solution in original post

2 REPLIES 2
qqqqqwwwweeerrr
Super User
Super User

Hi @Apple08 

 

if my understanding is correct, you want lenges irrespective of filters. i treid to do similar thing hope this will help you also. 

Step 1: Create a table with distinct value for category (A, b... etc), 

Table = DISTINCT(Piechart[Category])
Step 2: join both the table: 
qqqqqwwwweeerrr_0-1712918736156.png

After thet use category in pie chart 

qqqqqwwwweeerrr_1-1712918780815.pngqqqqqwwwweeerrr_2-1712918804839.png

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: https://www.youtube.com/@letssolveproblem

Regards



It works perfectly!  Thank you so much for your help.  🙂

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.