Forum Discussion

Apple08's avatar
Apple08
Icon for Helper IV rankHelper IV
3 years ago
Solved

Legends do not updated after view as role

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 ...
Need Help
  • AntonioM's avatar
    AntonioM
    3 years ago

    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's avatar
Apple08
Icon for Helper IV rankHelper IV
3 years ago

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's avatar
AntonioM
Icon for Solution Sage rankSolution Sage
3 years ago

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's avatar
    Apple08
    Icon for Helper IV rankHelper IV
    3 years ago

    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's avatar
    AntonioM
    Icon for Solution Sage rankSolution Sage
    3 years ago

    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's avatar
    Apple08
    Icon for Helper IV rankHelper IV
    3 years ago

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