Forum Discussion

rbiswas's avatar
rbiswas
Frequent Visitor
9 years ago
Solved

comments in power BI

Hi all,

 

I facing an issue in implementing comment in power BI.

 

Suppose ,  i have source table with comments by country.

 

 

In the Report , I need to have a textbox/ card having the comments which get filtered based on what country I choose, and if no selection is made then there should be a global comment by default.

 

 

 

 

Need Help
  • Dog's avatar
    Dog
    9 years ago

    best to create a New Measure which looks for a single value being returned once filtered. 

     

    ShowComment:=
    IF (
    HASONEVALUE ('TableName'[Comments] ),
    VALUES ( 'TableName'[Comments]),
    "Generic Comment"
    )

     

    wasn't sure of your table name so that will just need replacing, 

3 Replies

  • Dog's avatar
    Dog
    Icon for Responsive Resident rankResponsive Resident
    9 years ago

    best to create a New Measure which looks for a single value being returned once filtered. 

     

    ShowComment:=
    IF (
    HASONEVALUE ('TableName'[Comments] ),
    VALUES ( 'TableName'[Comments]),
    "Generic Comment"
    )

     

    wasn't sure of your table name so that will just need replacing,