Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hallo,
is there a possibility to remove only parts of the legend?
I have the following diagram:
and would like to remove only the part highlighted in red.
Thanks in advance
Solved! Go to Solution.
Hi @PeterP20 ,
Are there three columns in line and column chart?
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.
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.
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:
Hi @PeterP20 ,
Are there three columns in line and column chart?
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.
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.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@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:
________________________
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 🙂
⭕ 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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
89 | |
88 | |
82 | |
64 | |
49 |
User | Count |
---|---|
125 | |
111 | |
88 | |
69 | |
66 |