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

Hi,

 

I am looking for maybe, a similar solution..... 

 

I have created certain measures like mSumPhaco, mSumSICS and mSumFreeCataract and have plotted it on clustered column chart. Obviously, name of the measures are appearing as legends. I wish to change the legends as per the image below. One way of doing so is ofcourse renaming the measures, but I do not want to do so.

Can that be achieved?

 

Thanks.

  • AdamBuckley's avatar
    AdamBuckley
    Frequent Visitor
    7 years ago

    Hi - You can rename the legends from the fields menu

     

    • deepvibha's avatar
      deepvibha
      Advocate II
      7 years ago

      AdamBuckley Thank you. This was introduced in one of the updates. Thank you anyways.

  • edejes2's avatar
    edejes2
    Advocate IV
    9 years ago

    Hello deepvibha,

     

    We discussed your question during the "Forum Aid" event of our user group.

     

     You can try adding a custom column with the following  if Text.Contains([ColumnName], "A") then "A" else "B"

     

    Best regards,

    Global & Virtual Power BI User Group

    • 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
    7 years ago

    Hi Did you solved this problem,because i am also stuck in the same promblem,want to update the legend name of pie chart.