Join the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now
#QuestionForGroup
Hi Guys, Need a help in sorting tooltips for a field parameter based Absolute and % selection.
Now the dynamics of the tables and graphs cant be changed any more so please let me know if this is possible in any work around or not. And if possible the step by step guide to it…
Table A
Fruits. Time periods(Jan26, Feb26…)
Apple - 1, 2, 5, 10, 15
Grapes - 3, 8, 23, 15, 16
Oranges - 7, 9, 14, 17, 25
Now I have a calculations which ask me to do how much apple in March26 suppose. So my 1st calculation- (absolute value) is 5 and 2nd calculation-(% of total) is 5/33*100.
So in order to do this I used field parameters(2 calculations and accordingly a slicer with abs and % filter)and plotted them using stacked column chart.
Default tooltips are not sorted now. Can we do a custom tooltip here,that on user-selection of abs it will be sorted and similarly for % it will be sorted?
Again repeating that the abs and % calculation are needed and hence done and used them as parameters.
Please let me know if this is possible with field parameters.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.