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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
kagu
Frequent Visitor

Field paramters: two different dimensions

Hi everyone,

I try to build an table, which is filterd by a field parameter.

kagu_0-1690551203026.png

 

 

Field_Act FY23 Val-Vol = {
    ("FY23", NAMEOF('Measures_Volume FY23'[Volume FY23]), 0),
    ("FY23", NAMEOF('Measures_Value FY23'[Value FY23]), 1)
}

 

 

This works really good.

 

Now I want to add additional the same two values from FY24 and want to add an extra filter. But I do not know how to combine it with my last one.

 

Thanks in advance for your help.

2 ACCEPTED SOLUTIONS

Then adjust your Parmeters accordingly, without mixing fiscal years and product types.

View solution in original post

kagu
Frequent Visitor

I tried this first with 

Type = 
SWITCH(TRUE(),
CONTAINSSTRING('Field_Val-Vol'[Val-Vol Felder],"Anzahl"), "Volume", "Value")

and hat problems when there were tw row s with Volume or Value.

 

Now I added 

Type Value = IF (CONTAINSSTRING(Parameter[Parameter Felder],"Anzahl")=True, "Volume", "Value")

and it works 

View solution in original post

4 REPLIES 4
lbendlin
Super User
Super User

Your request is not clear. Do you want this?

 

Field_Act Val-Vol = {
    ("FY23 Volume", NAMEOF('Measures_Volume FY23'[Volume FY23]), 0),
    ("FY23 Value", NAMEOF('Measures_Value FY23'[Value FY23]), 1),
    ("FY24 Volume", NAMEOF('Measures_Volume FY24'[Volume FY24]), 2),
    ("FY24 Value", NAMEOF('Measures_Value FY24'[Value FY24]), 3)
}
kagu
Frequent Visitor

Yes. But I do want two slicers. One for FY23/FY24 and one for Volume/Value.

Then adjust your Parmeters accordingly, without mixing fiscal years and product types.

kagu
Frequent Visitor

I tried this first with 

Type = 
SWITCH(TRUE(),
CONTAINSSTRING('Field_Val-Vol'[Val-Vol Felder],"Anzahl"), "Volume", "Value")

and hat problems when there were tw row s with Volume or Value.

 

Now I added 

Type Value = IF (CONTAINSSTRING(Parameter[Parameter Felder],"Anzahl")=True, "Volume", "Value")

and it works 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.