Forum Discussion

anjanikumar's avatar
anjanikumar
Icon for Helper III rankHelper III
11 months ago
Solved

By using field parameters showing data revision wise !!

I have a field parameters contain dimensions FY, Revision, Segment,Supply main Category, Product Group,PA,HFB   I am using clustres column chart Using x axis : parameter Y axis : Tatical Need, O...
Need Help
  • mh2587's avatar
    mh2587
    11 months ago
    Tactical Need (Dynamic) = // Try this if it works, do the same for order
VAR _SelectedParam =
    SELECTEDVALUE('Field Parameter'[Name])  // name of your field parameter
VAR _CurrentRevision =
    SELECTEDVALUE('Revision'[Revision])
RETURN
IF(
    _SelectedParam = "Revision",
    [Tactical Need],  // show all revisions
    IF(_CurrentRevision = "V3", [Tactical Need])  // show only V3 for others
)
mh2587's avatar
mh2587
Icon for Super User rankSuper User
11 months ago
Tactical Need (Dynamic) = // Try this if it works, do the same for order
VAR _SelectedParam =
    SELECTEDVALUE('Field Parameter'[Name])  // name of your field parameter
VAR _CurrentRevision =
    SELECTEDVALUE('Revision'[Revision])
RETURN
IF(
    _SelectedParam = "Revision",
    [Tactical Need],  // show all revisions
    IF(_CurrentRevision = "V3", [Tactical Need])  // show only V3 for others
)