Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Hi @Anonymous, can you provide some screenshots of what you mean as I'm not sure at the moment?
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,
NareshImage1
Image2
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |