Forum Discussion
Custom name legend
Your scenario is still confusing me. Maybe you're looking for something as below?
- Unpivot the table.
- Split the Product column by dot.
- Rename the column properly.
In report window, to avoid confusion, instead of individual pie charts, use one chart with slicer. Create a measure Product Indicator and show it in a Card visual.
Product Indicator = IF(ISFILTERED('Table'[Product]),LASTNONBLANK('Table'[Product],""),"all product")Check more details in a
If you right click the measure you can re-name the measure, that will reflect in your legend. Likewise, you can add a custom legend accessing the setting of the visualization.
I am not clear when you said that " Without remaining the measures" you don't want the measure that you apply?.
Best regards,
Global & Virtual Power BI User Group
I'm not sure why there is so much confusion around this question. I too am trying to accomplish what a few others are in this thread.
Simply, when you display a legend in a bar chart for example, the legend uses the name of the measures or columns. We wish to change the display name of the measures/columns in the Legend on the chart without renaming the actual measure/column. Power BI provides an option to give the Legend a title, but can you add a function so that we can change the display name for the measure/column?
Hi, I am new to using Power BI.
I was trying to solve exactly the same issue, but couldn't find the solution here.
What I did was - create a table containing two columns:
Col1: the legend types/names that you are trying to change on your report visual - use this column as an ID to create relationship with the current table.
Col2: The names/titles you would like to be displayed on your visual
Put your 2 original tables in the Axis, and add the new table we just created in the Axis as well - you now have 3 tables in the Axis.
Put the new table we just created into Legend. Hope it works for you too!
Thanks Iyasolis. I will give it a try and respond.
Hi, is there a solution to this?
I have a demand which is very similar,to show the last 3 years gross profit distribution per product.
for this i chose clustred column visualization.
for this i created 3 measures:
Gross Profit 2 years ago
Gross Profit Last Year
Gross Profit
All are based on a ParallelPeriod calculation.
I get the desired results, but the data legend takes the name of the measure automatically.
The year where the data presentation begines is deterimned by a slicer as shown here:
Since these measures show the gross profit dynamically at the selected year,as well as 1 and 2 years prior to that year the legend shown for these measures is the name of the meaure (i.e. Gross Profit)
Now as each of these meaures represesnts data from a single year only, i would like the legend to take dynamic naming according to the year i calculates.
so if i am inspecing 2016, then i want to see at teh legend:
Gross Profit 2 years ago -->2014
Gross Profit Last Year --> 2015
Gross Profit --> 2016
can this be achieved?
Thank you,
Tal
