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
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
Hi
I have a demand 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