Legends do not updated after view as role

[Apple08]

Hi All

I have a chart below showing two suppliers' measures A and B in percentage.  They are two seperate measures one for A and one for B.  I have setup 'manage roles' for A and B, however when I view as A or B, the legend remains unchanged showing both A and B legends.  Please could anyone help me to sort this issue out?

Before view as A or B:

After A is selected in the view, the legends also include %B in the red box below:  If B is selected, A is also included in the legends, so the legends didn't update itself.

Any help is appreciated.  Thanks.

[AntonioM]

Hi @Apple08 ,

I think because you've created two measures, both are always going to show in the legend.

When you view as A, although there's now no data for B, the % B measure is still in the visual so still shows in the legend - even though it's now blank.

Is there a way you can write a general % measure and then use a column with A and B values as the legend of the chart? That would stop B appearing in the legend as when viewing as A.

[Apple08]

Thanks AntonioM.  My two measures are as below:

% A = divide([A Actual hours measure],[A Capacity Hours Measure])

%  B = divide([B Actual hours measure],[B Capacity Hours Measure])

A and B are in the 'Supplier'[Name].  I wonder how can I make them into one measure?  Thanks.

[AntonioM]

So could you create a generic [Actual Hours Measure] and [Capacity Hours Measure]? Just the totals, without any filtering on the name.

Then you could create % = DIVIDE ( [Actual Hours Measure], [Capacity Hours Measure] ) and put 'Supplier'[Name] in the legend of the chart.

Would that work?

[Apple08]

Thanks.  I did try but the total combined into one line only rather seperate A and B into two lines.

[AntonioM]

Ok, could you tell me what the Actual and Capacity measures are? And maybe share some of the data in the table you're using

[Apple08]

Thanks AntonioM.  

There is a table 'Supplier' of capacity hours for suppliers A and B by month for the whole financial year.

Capacity Hours Measure = sum('Supplier'[Capacity Hours])

The actual hours are obtained from anther table 'Task' and I get the actuals into the Supplier table by DAX below:

Actual Hours = SUMX(FILTER(Task[name]='Supplier'[name] && Task[MMM-YY]='Supplier'[MMM-YY]),Task[Actual])

Actual Hours measure = sum('Supplier'[Actual Hours])

[AntonioM · Accepted solution]

Hmm ok, just to check you have:

'Supplier'[MMM-YY] on the x axis

% = DIVIDE ( [ Actual Hours Measure], [Capacity Hour Measure] ) on the y axis

'Supplier''[Name] in the legend

[Apple08]

Thanks!  It works on the line graph 🙂

However, when I switch the graph to line and clustered column chart to show the column with % Plan vs Capacity, the lines showing % Actual vs Capacity, then only column legend is avaible to show A & B % Plan, but the line remains in one only.  I wonder is there anyway to split up the lines to second y-axis?  Many thanks.

[AntonioM]

Unfortunately, I don't think there is; the combo charts only allow one line.

There is an idea Microsoft Idea (powerbi.com) for exactly this but it's not a feature yet.

The only way to add more lines is with separate measures, but that's back to where we started again.

[Apple08]

Thanks AntonioM for your kind explaination and effort.  I appreciate your help so much.  🙂