Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone!
I'm trying to show in a graph some values and its names or description, per month.
For example:
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
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
The easiest way would be to place Object in the Legend like this
Otherwise you have to write Measures for each Object and place in the tooltips like this...
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!
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?
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...
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:
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.
@chrisgehm First Unpivot the Data as shown here...
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
Seems the correct answer, but when I try to unpivot table, nothing apears:
Hi @chrisgehm,
Have you tried the solution provided by Sean above? If you still have any problem on this issue, feel free to post. 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
In the Query Editor - try selecting only the 3 Amount Columns - Unpivot - Close and Apply (its basically the same thing but try it)
User | Count |
---|---|
139 | |
113 | |
103 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |