Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Drillup/Drilldown function not working in matrix visual when multiple measures selected from slicer.

Hello All,

I have created a measure for selection from slicer.

Measure_Selection =
SWITCH(
SELECTEDVALUE( 'DynamicMeasureTable'[Measure],1),
1 ,'Measure Table'[Measure 1],
2 ,'Measure Table'[Measure 2] * 100,
3 ,'Measure Table'[Measure 3] ,
4 ,'Measure Table'[Measure 4]* 100,
5 ,'Measure Table'[Measure 5],
6 ,'Measure Table'[Measure 6]*100,
7 ,'Measure Table'[Measure 7],
8 ,'Measure Table'[Measure 8]*100,
9 ,'Measure Table'[Measure 9],
10,'Measure Table'[Measure 10]*100,
11,'Measure Table'[Measure 11],
12,'Measure Table'[Measure 12 100,
13, 'Measure Table'[Measure 13],
14, 'Measure Table'[Measure 14]* 100,
15,'Measure Table'[Measure 15],
16,'Measure Table'[Measure 16]* 100
)

While i using  this measure in Matrix visual, selected mutiple values from slicer and drill up it is not working as expected(multiple cloumns should drillup and show related data). Only Single column is drilling up.

By using Switch function only its allows sing values selection, is there any way for multiple selections. Please suggest.



Thanks,
Naresh
nareshkandala.21@gmail.com


2 REPLIES 2
Russell-PBI
Resolver II
Resolver II

Hi @Anonymous, can you provide some screenshots of what you mean as I'm not sure at the moment?

Anonymous
Not 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 Image1

But 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,
NareshImage1Image1Image2Image2

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors