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
chrisgehm
Helper III
Helper III

Show components while passing mouse over graph

Hi everyone!

 

 

I'm trying to show in a graph some values and its names or description, per month.

For example:

1.PNG

 

So what I want is that when I move the mouse over the graph, to show each elemment tha is in the month I step over

 

2.png

 

For example, in the image, if I stand over month 1, I would like to show the month, the total amount, and each object that is in that month. In the case I choose month 1, I would like to show object A, B and C.

 

Is it possible?

 

Kind regards

12 REPLIES 12
Sean
Community Champion
Community Champion

The easiest way would be to place Object in the Legend like this

Setup1.png

Otherwise you have to write Measures for each Object and place in the tooltips like this...

Setup2.png

The Measures are very simple however depending on how many you actually have it may take some time

Object A = CALCULATE ( SUM('Table'[Amount]), 'Table'[Object]="A")
Object B = CALCULATE ( SUM('Table'[Amount]), 'Table'[Object]="B")
Object C = CALCULATE ( SUM('Table'[Amount]), 'Table'[Object]="C")
Object D = CALCULATE ( SUM('Table'[Amount]), 'Table'[Object]="D")

Hope this helps!Smiley Happy

Thanks for the answer @Sean

 

Actually, I've got over 1000 objects, so I can't do a measure for each object.

I've tryed to drag "Object" to the legend field, but I can't.

 

Any idea why?

Sean
Community Champion
Community Champion

Well I know you can't place a Measure in the Legend! What is Object?

Object is text, but I have other vales apart amount to show.

There are 3 numeric values, per month, so I'm a bit lost with this...

Sean
Community Champion
Community Champion

Can you post some sample data? I think the first sample you posted was oversimplified.

Sure @Sean,

I'v got this table, with 3 amounts:

1.PNG

 

What I need to do, is to show in a chart graph, per month the 3 amounts.

And when I step over the chart, per month, I need to show whici object is in that month.

Sean
Community Champion
Community Champion

@chrisgehm  First Unpivot the Data as shown here...

 

Query Editor - Setup Step 1.gif

 

Then You'll need this MEASURE

Amounts 1,2,3 = IF ( HASONEVALUE ( Table1[Object] ), CONCATENATEX ( Table1, Table1[Value], ", " ) )

This will allow you to create the Chart and also the Matrix shown below.

Here's the result Smiley Happy

 

Setup3.png

 

Seems the correct answer, but when I try to unpivot table, nothing apears:

 

1.PNG

Hi @chrisgehm,

 

Have you tried the solution provided by Sean above? If you still have any problem on this issue, feel free to post.Smiley Happy If not, please accept the helpful reply as solution to help others who may have similar issue easily find the answer and close this thread?

 

Regards

@v-ljerr-msft I mean, I've tryed, but the other reports I've done stoped working while unpivoting the table.

@v-ljerr-msft Hi, as I can't unpivot the table (don't know what happen with the things I've already done) I'm still searching for other solution.

 

Kind regards

Sean
Community Champion
Community Champion

In the Query Editor - try selecting only the 3 Amount Columns - Unpivot - Close and Apply (its basically the same thing but try it)

 

Query Editor - Setup Step 1a.gif

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.