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
PeterP20
New Member

Remove part of the legend

Hallo,

is there a possibility to remove only parts of the legend?

I have the following diagram:

 

grafik.png

and would like to remove only the part highlighted in red.

 

Thanks in advance

1 ACCEPTED SOLUTION
v-zhenbw-msft
Community Support
Community Support

Hi @PeterP20 ,

 

Are there three columns in line and column chart?

 

remove1.jpg

 

If yes, there is no way just to close one legend.

Perhaps you can submit the requirement to ideas and add your comments there to make this feature coming sooner: https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

Or you can insert a rectangle and configure it as white to cover on the legend.

 

remove2.jpg

 

remove3.jpg

 

Best regards,

 

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
Syndicate_Admin
Administrator
Administrator

Hello PeterP20.

I do not know if you still have the doubt but I hope this helps:

To modify the text of the legend you must select the graphic and in the visualizations menu locate the axis where the element to be modified is located. Click on the down arrow and select the option rename this visual object, so in the legend the desired text will appear:

Jadm_0-1675170607165.png

v-zhenbw-msft
Community Support
Community Support

Hi @PeterP20 ,

 

Are there three columns in line and column chart?

 

remove1.jpg

 

If yes, there is no way just to close one legend.

Perhaps you can submit the requirement to ideas and add your comments there to make this feature coming sooner: https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

Or you can insert a rectangle and configure it as white to cover on the legend.

 

remove2.jpg

 

remove3.jpg

 

Best regards,

 

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

mahoneypat
Employee
Employee

Not sure if you need the legend column in both long and short forms, or just short, but you can make a custom column in the query editor (transforming existing column or adding new) using Text.AfterDelimiter().  Or you can make a DAX calculation column using RIGHT() or a more advanced one with SEARCH and RIGHT if the # of characters after the dashes is variable.  You can then use the new column for your legend.

Regards,

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Fowmy
Super User
Super User

@PeterP20 

Select the chart, click on the Filter Pane on the right and click on the Legend Fields then untick the values that you do not need in the chart.

 

Example:

Fowmy_0-1608477101358.png

 

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

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


Website YouTube  LinkedIn

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

I could not really fix the problem with that.

The filter of the value is set to nothing and I really don't want to filter data sets out. I just want the whole Attribute to not appear in the legend.

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.