Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

can we hide legend labels

Hi All,

 

We have used a line chart which shows Total Finalised Plans of Stores over time.

When we select multiple stores it needs to show all stores with different colors(Legend), but when we select all stores It needs to shoe only single line: To solve this I had used following measure:

 
Finalized plans =
IF(COUNTROWS(DISTINCT(ALLSELECTED(AutoFinalised[Store]))) < COUNTROWS(DISTINCT(ALL(AutoFinalised[Store]))),
SUM(AutoFinalised[Plan]),
CALCULATE(SUM(AutoFinalised[Plan]),ALL(AutoFinalised[Store]))
)

 

My problem here is that, when we show multiple stores, the legend shows their contribution as shown below:

But When selecting all lines and you hover over the stores should not show their own contribution but shows single value as below:

Expected Result:

When we select All stores, it needs to show a single line and legend show their own contribution and not a single value as 81.

 

Thanks,

4 Replies