Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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:

leg1.png

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

leg2.png

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,

2 ACCEPTED SOLUTIONS
Greg_Deckler
Super User
Super User

Use a report page tooltip.

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

amitchandak
Super User
Super User
4 REPLIES 4
amitchandak
Super User
Super User

Anonymous
Not applicable

Hi @amitchandak 

 

Thank for Solution

Greg_Deckler
Super User
Super User

Use a report page tooltip.

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

Thank You so much, The Report level Tooltip is Working Fine.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.