Forum Discussion

SuryaDave's avatar
SuryaDave
Helper 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
Helper I
1 year ago

Thanks danextian  for your response. 

Apologies for very late response  - I was travelling and then got busy with few urgent items.

 

Regarding your response - I really liked your idea  of using selected value 

SELECTEDVALUE ( 'table'[format string] )

However, somehow I was not able to get it to work just like that. 
So what I did was  created look up table - see screenshot below 

 

 

I then joined then using may to one with my original table  and then as last step created below format string & that is working perfectly.

 

danextian - can you please see if that is something that you think is a solution  or you have bettter suggestion.

I will for your response & accordingly I will accept suggestion as solution to make sure that someone having the same problem can find the correct solution throught this forum.

I would also like to thanks lbendlin , Ashish_Mathur & v-aatheeque  for your contribution and suggestion. Feel free to provide further input on the basis of my these post and screenshots I have attached.

Thanks

danextian's avatar
danextian
Super User
1 year ago

For SELECTEDVALUE (['table'[format string] ) to work string to work, it must be in the same table as those used in the visual.