Forum Discussion
Dynamic Table with field parameter and two value slicers partially working.
- Anonymous1 year ago
Hi jctasu ,
When switching slicers, because you have two 1 is in the field parameter, you may not be able to correctly recognize which 1 is which when switching and use the correct parameter.
The solution is to create a calculated column that references the column in the Filed parameter that applies to the slicer, and then reference that calculated column in the measure syntax.
As you can see below, this is the simple field parameter I created:
Create a calculated column:
Create a measure:
Measure = VAR _cv = IF ( [CV Cur] < SELECTEDVALUE ( 'Lower Limit'[Lower Limit] ) || [CV Cur] > SELECTEDVALUE ( 'Upper Limit'[Upper Limit] ), 1, 0 ) VAR _sv = IF ( [SV Cur] < SELECTEDVALUE ( 'Lower Limit'[Lower Limit] ) || [SV Cur] > SELECTEDVALUE ( 'Upper Limit'[Upper Limit] ), 1, 0 ) RETURN IF ( MAX ( 'Parameter'[Column] ) = "CV", _cv, _sv )Apply measure to your visual objects.
If this does not solve your problem, please provide a Power BI Desktop file (with sensitive information removed) that comprehensively covers your issue or question in a usable format (not a screenshot). You can upload the PBIX file to a cloud storage service such as OneDrive, Google Drive (set to public access), SharePoint, or a Github repository and then share the URL of the file.
If you have any other questions please feel free to contact me.
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
Hi jctasu ,
When switching slicers, because you have two 1 is in the field parameter, you may not be able to correctly recognize which 1 is which when switching and use the correct parameter.
The solution is to create a calculated column that references the column in the Filed parameter that applies to the slicer, and then reference that calculated column in the measure syntax.
As you can see below, this is the simple field parameter I created:
Create a calculated column:
Create a measure:
Measure =
VAR _cv =
IF (
[CV Cur] < SELECTEDVALUE ( 'Lower Limit'[Lower Limit] )
|| [CV Cur] > SELECTEDVALUE ( 'Upper Limit'[Upper Limit] ),
1,
0
)
VAR _sv =
IF (
[SV Cur] < SELECTEDVALUE ( 'Lower Limit'[Lower Limit] )
|| [SV Cur] > SELECTEDVALUE ( 'Upper Limit'[Upper Limit] ),
1,
0
)
RETURN
IF ( MAX ( 'Parameter'[Column] ) = "CV", _cv, _sv )
Apply measure to your visual objects.
If this does not solve your problem, please provide a Power BI Desktop file (with sensitive information removed) that comprehensively covers your issue or question in a usable format (not a screenshot). You can upload the PBIX file to a cloud storage service such as OneDrive, Google Drive (set to public access), SharePoint, or a Github repository and then share the URL of the file.
If you have any other questions please feel free to contact me.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!