Level Up your Power BI Game with Field Parameters! (with Nikola Ilic)

แชร์
ฝัง
  • เผยแพร่เมื่อ 10 พ.ย. 2024

ความคิดเห็น • 18

  • @ThePilli41
    @ThePilli41 8 หลายเดือนก่อน +1

    Amazing video!
    just a quick shout out to both Nikola and Reid, below is the Treatas formula:
    Sel Value =
    VAR SelectedValue =
    SELECTCOLUMNS (
    SUMMARIZE (
    'Param Treatas',
    'Param Treatas'[Param Treatas],
    'Param Treatas'[Param Treatas Fields]
    ),
    'Param Treatas'[Param Treatas]
    )
    RETURN
    "Selected value from FP is: "
    & IF ( COUNTROWS ( 'Param Treatas' ) = 1, MAX ( 'Param Treatas'[Param Treatas] ) )
    // (COUNTROWS(_SelectedValue),_SelectedValue)

  • @LucaGanugi
    @LucaGanugi 8 หลายเดือนก่อน

    Another great usage of field parameter is to let the user to customize ad hoc a matrix for example, just letting them to select what dimensions to see and in what order. If you multiselect some values inside the field parameter, those dimensions are displayed in the very same order as you click, letting to dinamically change grouping.

    • @HavensConsulting
      @HavensConsulting  8 หลายเดือนก่อน

      Absolutely, it's essentially what I showcase in this video I released a few weeks back :)
      th-cam.com/video/ly63K6i9uxk/w-d-xo.html

  • @workstuff5253
    @workstuff5253 7 หลายเดือนก่อน +1

    Hi Reid. I wasn't clear if the video already exists or not, but I'd love to see you demo the technique you were describing @1:04:11. Cheers

    • @HavensConsulting
      @HavensConsulting  7 หลายเดือนก่อน +1

      This one one of them, using the field parameter order column as a key :)
      th-cam.com/video/KG1S_7BlqAY/w-d-xo.html

  • @scramiro1
    @scramiro1 8 หลายเดือนก่อน +1

    Can anybody point me to a video o blog explaining how to retain a hierarchy expanded when changing the selection of the field parameters.. I've read you can, but can't find the how to with details. Thanks

    • @HavensConsulting
      @HavensConsulting  8 หลายเดือนก่อน

      That would be news to both Nikola and I. As neither of us has seen a way around this limitation. It was the topic of the field parameters vs calculation groups video I did a few weeks ago, and that having the hierarchy below a field parameter reset, because the structure of the query changes.

  • @carltonseymour869
    @carltonseymour869 8 หลายเดือนก่อน

    Awesome examples showcasing Field Parameters

    • @HavensConsulting
      @HavensConsulting  8 หลายเดือนก่อน

      Glad you liked it!

    • @carltonseymour869
      @carltonseymour869 8 หลายเดือนก่อน

      I actually used in in a project and worked like MAGIC@@HavensConsulting

  • @muhammetmuslu4429
    @muhammetmuslu4429 8 หลายเดือนก่อน

    I love field parameter more now.thank you

  • @VijayYadav-tx6ft
    @VijayYadav-tx6ft หลายเดือนก่อน

    Could you please me how can use multiple fields parameters with help of data modeling

    • @HavensConsulting
      @HavensConsulting  หลายเดือนก่อน

      Hi there! Could you elaborate on your question? What do you mean by "using multiple field parameters"?

  • @JBartlett_DMU
    @JBartlett_DMU 4 หลายเดือนก่อน

    Hey Reid, I just found out that it's possible to create Field Parameters with a Tabular Editor script, so you're not limited to only creating them in Power BI Desktop anymore. GIAC did a video demonstrating the technique back in January, and it's called "Can you use Field Parameters with Direct Lake in Power BI?": th-cam.com/video/Cg6zRhwF-Ro/w-d-xo.html

    • @HavensConsulting
      @HavensConsulting  4 หลายเดือนก่อน +1

      Heck yeah, thanks for that!

  • @powerbinareal
    @powerbinareal 5 หลายเดือนก่อน

    Urra!!!!!