Custom name legend

[Z7-852]

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 faults of each type occures.

What I need help with is naming the legends for these charts. By default they say Product1.FaultA and so on. But this is long and confusing because there are only data from single product in this chart. I would like to rename legends without renaiming columns in data.

[TalAruety]

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:

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

[TalAruety]

Hi, is there a solution to this?

I have a demand which is very similar,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:

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

[NehaVageriya]

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]

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

[ankitpatira]

@Z7-852 For pie chart visual under paintbrush icon, you do have option to rename Legend or even turn it off. You can also rename column in your data set.

[Z7-852]

Solution given by @ankitpatira is not what I'am looking for.

From format you can give a title for legends. This is not what I need.

I need to rename variables without changing their names in the data set. If I chance names in data set I would have to columns both names "Fault A" and I wouldn't know which is for product 1 and which is for product 2.

[ankitpatira]

@Z7-852

So do you mean changing values of actual rows ? In that case you will have to do replace values via query editor to replace values of actual rows in column which will become legend in pie chart.

[Z7-852]

@ankitpatiraNo I don't want to chance any values.

I have data with columns named "Product1.FaultA", "Product1.FaultB", "Product2.FaultA", "Product2.FaultB" and so on. These variables are binary data (0 = no fault, 1 = fault)

I draw 2 pie charts. In the first I use variables Product1.FaultA and Product1.FaultB. These columns are summed giving me answer how many FaultA and FaultB are in all of the Products1. Same is done for product2.

Now I set legends on. Legends say "Product1.FaultA", "Product1.FaultB" in the first chart and "Product2.FaultA", "Product2.FaultB" because these are the variable names. For reader this is confusing because first chart only contains Product1 faults. So legends shouldn't say Product1.FaultA but only FaultA. If I rename columns I would end up with two FaultA columns (one for product1 and one for product2).

I'am not even sure if this is possible, but for estetic point of view it would be nice.

[Eric_Zhang · Accepted solution]

@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

[itayrom]

One thing you could try is creating a calcuated table with three columns-

1. "Product" - The name of the product.

2. "FaultA" - The sum of that product's FaultA column.

3. "FaultB" - The sum of that product's FaultB column.

Polulating them with the products you want to show in the pie charts, and then creating several pie-charts, each with "FaultA" and "FaultB" as their values sources, and a visual level filter applied on each one, in order to make them show only the values of a specific product.

You can achieve this by performing the following steps:

1. In the "Modeling" ribbon's "calculations" section, click on the "New Table" button.

2. Enter a DAX expression representing the table you want to create. For example, you can create a UNION of ROWs. For Example-

DisplayableProductsTable = UNION(
    ROW("Product", "Product1", "FaultA", SUM(srcTable[Product1.FaultA]), "FaultB", SUM(srcTable[Product1.FaultB])),
    ROW("Product", "Product2", "FaultA", SUM(srcTable[Product2.FaultA]), "FaultB", SUM(srcTable[Product2.FaultB])),
    ROW("Product", "Product3", "FaultA", SUM(srcTable[Product3.FaultA]), "FaultB", SUM(srcTable[Product3.FaultB]))
)

3. Add a pie-chart to your page and put the FaultA and FaultB in its "values" field well.

4. Add the Products column to the pie-chart's visual level filters field well and select a product to have only its values shown.

5. Repeat steps 3 - 4(Or copy and paste the first pie-chart).