Forum Discussion

SuryaDave's avatar
SuryaDave
Icon for Helper I rankHelper I
1 year ago
Solved

Dynamic String Format

Hello experts, My question to relates to the dynamic string that are now available in Power BI. Btw I am using latest Power BI desktop and my original file is on our cloud server ( premium )  ...
Need Help
  • v-aatheeque's avatar
    v-aatheeque
    1 year ago

    Hi SuryaDave 

    Just to help further (and in case it’s helpful for anyone else referencing this thread), I’ve created a sample .pbix file that demonstrates the SELECTEDVALUE pattern

    Hope it helps!!

SuryaDave's avatar
SuryaDave
Icon for Helper I rankHelper I
1 year ago

thanks lbendlin  for your response. I actually checked couple of videos on calculation group but I noticed that it still requires formatting to be hardcoded. 
My question is how can I create a reference table or look up table - that I can point to for dynamic string to read from apply formatting reading from that table ...

If you think that calculation group can solve that - any chance you can demo that with exmple - if that's ok ? 
Thanks

 

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

What you are looking for (dynamic evaluation) is sadly (or thankfully, depending on your viewpoint) not supported in Power BI Desktop or the UI in the service, namely the ability to run EVALUATE.  (It is possible to do that in external tools, and in Embedded scenarios)

 

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com