Forum Discussion

anjanikumar's avatar
anjanikumar
Helper III
10 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, Order

 

Now when I filter with Revison I need to show all 3 revisions in x axis rest of all fields(FY, Segment, Supply main category , Product group, PA, HFB) should show only V3 Revison

 

How to do it ?

Need Help
  • mh2587's avatar
    mh2587
    10 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
)

3 Replies

  • mh2587's avatar
    mh2587
    Super User
    10 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
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    9 months ago

    Hi anjanikumar,


    Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to mh2587  for prompt and helpful response.

    Just following up to see if the Response provided by community member were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.

     

    Best regards,
    Prasanna Kumar

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 months ago

    Hi anjanikumar,

     

    Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.

     

    Best regards,
    Prasanna Kumar