Forum Discussion

Ben83's avatar
Ben83
Icon for Advocate IV rankAdvocate IV
10 years ago
Solved

Text field to show the selected filter

I have created a report for the delivery reliability of our company. In this report I imported a long excel list with all of our delivery positions of a whole year. Every single delivery positions is...
Need Help
  • konstantinos's avatar
    konstantinos
    10 years ago

     You can try a measure that return text. You need to add it in a table , matrix or card visual.

     

    1. If you have a client column/table with unigue clients you can try this

     

    Clients Filtered =
IF (
    HASONEVALUE ( Clients[ClientName] );
    VALUES ( Clients[ClientName] );
    "ALL"
)

    2. If not you, you filter from fact table or other this option should work

    Clients Filtered 2 =
IF (
    COUNTROWS ( VALUES ( Sales[Client] ) ) = 1;
    VALUES ( Sales[Client] );
    "ALL"
)

    Hope that helps

     

     

konstantinos's avatar
konstantinos
Icon for Memorable Member rankMemorable Member
10 years ago

 You can try a measure that return text. You need to add it in a table , matrix or card visual.

 

1. If you have a client column/table with unigue clients you can try this

 

Clients Filtered =
IF (
    HASONEVALUE ( Clients[ClientName] );
    VALUES ( Clients[ClientName] );
    "ALL"
)

2. If not you, you filter from fact table or other this option should work

Clients Filtered 2 =
IF (
    COUNTROWS ( VALUES ( Sales[Client] ) ) = 1;
    VALUES ( Sales[Client] );
    "ALL"
)

Hope that helps

 

 

Jayanth's avatar
Jayanth
Regular Visitor
8 years ago

Hi,

 

 If i choose Age 30,40 and 50 it should display as the same in the text field and if i choose Select ALL it should be  display as 'ALL'  Below code only work for single select but not for Multiselect of Age from Drop down, Please help me

 

AFILTER = If(HASONEFILTER('UVN_CNSMR_CORE MSTR_CNSMR_PRFL'[AGE]),
VALUES ('UVN_CNSMR_CORE MSTR_CNSMR_PRFL'[AGE]),"ALL")

  • Pandu's avatar
    Pandu
    New Member
    8 years ago

    Hi Jayanth,

    Follow the below stpes to display multi select prompt values in text field.

     

    Iam giving example based on the year prompt in my scenario

     

     i) Create a measure (Text Filed)with the column Year

     

    Text Field = 
    IF( ISBLANK(
    CONCATENATEX (
     VALUES ( Sheet6[Year] ),
     Sheet6[Year],
     ", "
    )), BLANK()," In " & 
    CONCATENATEX (
     VALUES ( Sheet6[Year] ),
     Sheet6[Year],
     ", "
    ))

    ii) Use this measure for a CARD Visualization and OFF the Category Label Property.

     

    Thank You,

    Pandu.

     

     

    • SamirAlis's avatar
      SamirAlis
      New Member
      8 years ago

      PanduThank you for the brilliant solution!

       

      I basically combined with another if for situations that may need something more condensed if all selections are checked:

       

      Text Field = 
IF(ISFILTERED(Sheet6[Year]),

      IF( ISBLANK(CONCATENATEX (VALUES (Sheet6[Year]), Sheet6[Year], ", ")), BLANK(), 
CONCATENATEX (VALUES (Sheet6[Year]), Sheet6[Year], ", "))

      ,"ALL")

      I've replaced the fields I used with the fields Pandu referenced. For my situation, this worked perfectly when choosing selections in a drop down list of clients.

       

      Thank you!