Forum Discussion

ktt777's avatar
ktt777
Icon for Helper V rankHelper V
5 years ago
Solved

Customized comments in power bi

Hi all,

 

what is the good way to customize comments in power bi,

I created a table with country name and each comments in one column and use card as below .

I have a filter, once i filter for one country, then it only shows comments for that country only

Problem is the length of the comments varies, how can i make all the comments aligns to the left. 

Or is there a better way, like prepare all the comments in a power point/picture and then somehow link to it when filter changes

 

 

 

Need Help
  • MFelix's avatar
    MFelix
    5 years ago

    Hi ktt777 ,

     

    Instead of using a car visualization have you tried using a table/ Matrix visualization? You can make it with get only the first value if no filter is applied using a measure similar to this:

     

    Comments = IF(HASONEVALUE(Table[Country]),MAX(Table[Comments]))

     

1 Reply

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    5 years ago

    Hi ktt777 ,

     

    Instead of using a car visualization have you tried using a table/ Matrix visualization? You can make it with get only the first value if no filter is applied using a measure similar to this:

     

    Comments = IF(HASONEVALUE(Table[Country]),MAX(Table[Comments]))