Forum Discussion

Z7-852's avatar
Z7-852
Helper I
10 years ago
Solved

Custom name legend

I have data with following columns: Product1.FaultA, Product1.FaultB, Product2.FaultA, Product2.FaultB etc.   I want to draw two pie charts (one for product 1 and one for 2) that tell how many fau...
  • Eric_Zhang's avatar
    Eric_Zhang
    10 years ago

    Z7-852

     

    Your scenario is still confusing me. Maybe you're looking for something as below?

     


    1. Unpivot the table.
    2. Split the Product column by dot.
    3. 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

deepvibha's avatar
deepvibha
Advocate II
9 years ago

Thanks edejes2,

 

I think I was not very clear in my question... here it is again - in a screenshot format:

 

Being "Measures", there are no columns to be renamed with an "If" statement. 

 

If I have got you wrong... pl. let me know in details how to achieve it with your solution.

 

Thanks

 

edejes2's avatar
edejes2
Advocate IV
9 years ago

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

 

 

 

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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? 

    • lyasolis's avatar
      lyasolis
      Frequent Visitor
      9 years ago

      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!

      • deepvibha's avatar
        deepvibha
        Advocate II
        9 years ago

        Thanks Iyasolis. I will give it a try and respond.