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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.