Forum Discussion
Show components while passing mouse over graph
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 :smileyhappy:
Seems the correct answer, but when I try to unpivot table, nothing apears:
In the Query Editor - try selecting only the 3 Amount Columns - Unpivot - Close and Apply (its basically the same thing but try it)
Hi chrisgehm,
Have you tried the solution provided by Sean above? If you still have any problem on this issue, feel free to post.:smileyhappy: 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 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
v-ljerr-msft I mean, I've tryed, but the other reports I've done stoped working while unpivoting the table.