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

NehaVageriya's avatar
NehaVageriya
Advocate II
9 years ago

Hi, Did you find the solution for this problem ? As I am also stuck with the same.

 

Also the solution posted for this problem is incorrect and so this problem's status should be changed to "Not Solved"

Z7-852's avatar
Z7-852
Helper I
9 years ago

I used combination of unique queries with filters and visual level filters to archieve my goal.