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 Iyasolis. I will give it a try and respond.

TalAruety's avatar
TalAruety
Advocate I
9 years ago

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:

 

Example of my cluster column visual

 

 

 

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