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
Power BI seems to have a simple way of implementing this.
The first chart below shows the original labels that are populated based on the name of the measures. Follow the steps listed below to change the labels on your chart.
- Click your chart, and click the small triange next to the measure name on fields tab.
- Click the rename button and type the new Label that you want to show on the chart.
- Legend label is automatically updated with the new label value.
I hope this helps!!
Step 1
Step 2
Step 3
Best Regards,
Satbir Minhas
Hi Satbir, thanks for your reply.
What you suggest is well when the meaures are year specific.
In my case my measures are relative.
that is i have a measure for last yaer, twoyears ago etc.
so each time data is refreshed its calculated based on current time.
when i open my report in 2017, i want last year lable to be named 2016.
at 2018 however the label for the same meaure should be 2017, automatically.
Any way to implement that?
Thank you.