Forum Discussion
Dynamic Dimension based on Selected Slicer.
Hi,
I had one field which has two category values and I split them by custum method. Example below
Old Field New Field (Fruits) New Field(Vegetables)
Apple Apple Brinjal
Orange Orange Tommoto
Brinjal
Tommoto
Here my question is I need bar chart with single Dimenstion.
If I select fruits, it should show frutis as Dimenstion. or If I select Vegetables it should show Vegetalbles as Dimenstion.
My tried below Dax but it is not working.
New_Dim = if(SelectedValue(New Field(Vegetables))>0, New Field(Vegetables), New Field (Fruits) )
Hi Anonymous ,
Here are the steps you can follow：
1. Create measure.
Measure = if(SelectedValue('Table'[New Field(Vegetables)])<>BLANK(), MAX('Table'[New Field(Vegetables)]), MAX('Table'[New Field(Fruits)]) )2. Place [New Field(Vegetables)] in the slice, and place [Old Field] in the table
3. Result：
When a null value is selected, [New Field(Fruits)] is displayed:
When the field in [New Field(Vegetables)] is selected, the corresponding data is displayed
You can downloaded PBIX file from here.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
Hi Anonymous ,
Here are the steps you can follow：
1. Create measure.
Measure = if(SelectedValue('Table'[New Field(Vegetables)])<>BLANK(), MAX('Table'[New Field(Vegetables)]), MAX('Table'[New Field(Fruits)]) )2. Place [New Field(Vegetables)] in the slice, and place [Old Field] in the table
3. Result：
When a null value is selected, [New Field(Fruits)] is displayed:
When the field in [New Field(Vegetables)] is selected, the corresponding data is displayed
You can downloaded PBIX file from here.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous , I think a better idea would be a having a column and use that as filter
Type = if([col] in {"Apple","Orange"} , "Fruits","Vegetables")
Anonymous , syntax problem
Type = if([col] in {"Apple","Orange"} //condition
, "Fruits" //then value , only one
,"Vegetables" //else value only 1
)
You can also try switch : https://www.youtube.com/watch?v=gelJWktlR80
Anonymous
Watch This Video
https://www.youtube.com/watch?v=_U2M0Hkotl4&list=PLWQB3PEUJKRneu8fam5CaCMCdrIdT_zDD&index=3
Watch from 10:43 onwards to know what you asked here!
In the next video there are much more details!
Let me know if this helps!
