Forum Discussion
Drillup/Drilldown function not working in matrix visual when multiple measures selected from slicer.
Hi Anonymous, can you provide some screenshots of what you mean as I'm not sure at the moment?
- Anonymous4 years agoNot applicable
Hi Russell-PBI,
With example Screenshots in details providing.
When multiple values selected in slicer, In Matrix visual at lowest level granulality the selected multiple measures data
are getting in columns(This period's sales and Year to date) refere to Image1But when drillup to first level only single measure data (this period's sales) is getting refer to image2.
In Visulization pane under fields section -> values selection -> [Sales All Measure] measure is using.
Please find measure logic below:
Sales All Measures =
SWITCH(
SELECTEDVALUE('Measure Selection'[Code],1),
1,[Sales],
2,[Sales YTD],
3,[Sales QTD],
4,[Sales Same Period Last Year],
5,[Cost]
)
Here I want to achive drillup funcationality with multiple measures selections that is selected from silcer.
Please do the needful.Thanks,
NareshImage1Image2