Suppress 0 in Field Parameters
Hi guys, just wondering if you can help me with this... I created a field paramter based on two measures and added a bar-chart which now shows a lot of 0 values. In the filter pane I tried to exlude 0 and or blanks etc but it doesn't work as it will hide the content of the other field parameter. Example below: Dax Measure that causes the problem is the following: I tried both versions, but it does not change the outcome of the output. Admin = [Total Inspections]-[Physical] or Admin = IF ( ISBLANK ([Total Inspections] ), BLANK (), ( [Total Inspections]-[Physical] ) ) Field Parameter: Physical/Admin Slicer = { ("Physical", NAMEOF('Power BI - Inspections'[Physical]), 0), ("Admin", NAMEOF('Power BI - Inspections'[Admin]), 1) } This only happens when the Admin Slicer is selected. I can choose to not select 0 in the filter pane, but that hides all the Physical values then when Physical is selected. Thanks for your help.
Dynamic Field in Slicer based on Field Parameter selection
Hi PBI Community I have been stuck for a while on trying to build upon my Field Parameter into a slicer. I have a Field Parameter that switches between four columns (Min Quantity, Max Quantity, Avg Quantity, Confirmed Quantity). I need a Slicer / Filter that is populated by the field (4 columns, Min Price, Max Price, Avg Price, Confirmed Price), based on the selection in the field parameter. So e.g, if i were to select "Min Quantity" in my Field Parameter, the slicer would contain the "Min Price" column and so forth. I have looked into combining IF() and SWITCH(), but the Slicer won't accept the measures i have created as valid. All help is appreciated. Kind regards, Andreas
How to use DAX formula SELECTEDVALUE with Field Parameters
Dear Power BI community, I would like to ask for your help as I am trying to use DAX formula SELECTEDVALUE based on field parameters, however it is not doable based on the following error message: IF user selects between two value the (Amount USD & Amount LCL) the calculation should be changing based on that: DAX formula : Field Parameter: Visualization selection for Amount USD & Amount LCL: Would it be possible for someone to help how to change the DAX formula SELECTEDVALUE part to make it work? Thank you for your advice in advance. Wishing you a wonderful date. Adam
