Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

More Info Button

Hi,    In below table,last column shows the summary which is a big paragraph for every contract. Is there any way , I can show only first line of paragraph & than give a More Info+ button to see t...
Show and Tell
Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi Anonymous 

 

You can create a what-if parameter table like below.

Next, create a measure like below that will enable you to switch between both states and manipulate the length of the string 

Product Description = 
VAR __productDescription = SELECTEDVALUE ( 'Product'[ProductDescription] )
RETURN 
SWITCH(
    SELECTEDVALUE( showHideProductDesc[showHideProductDesc] ),
    0, LEFT( __productDescription, 10 ) & "...",
    1, __productDescription
)

 Finally, add the measure to the table and use the slider to switch between the options, as below.

FullShort

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Mariusz  What u mean by "what-if parameter table " , we can just create a parameter not table.

 

Request you to please describe.

 

Thanks...

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous He means create a table as per the image he showed.  

  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    Hi Anonymous 

     

    Sorry for not being clear enough, the below screenshot will explain what I meant by the "what-if parameter table".

    The above will create a table that later you can expand with an extra column with if statement like.

    Show Short or Full Description = IF( showHideProductDesc[showHideProductDesc] = 0, "Short", "Full")

     And later just add the measure provided in my previous post.

     

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn