More Info Button

[Anonymous]

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 the rest of the summary.

If not More Info+ button than, at least a simple maximize minimize button, if the user wants to see he will open that.

Regards,

Ashraf 

[parry2k]

@Anonymous in past I create two table visuals, one on the top without big paragraph and 2nd table visual on the same page with paragraph column, so when users select a row in a top table visual, it will show paragraph at the bottom, it is much cleaner look (in my opinion), and you can hide paragraph table visual and only show when a row in a top table visual is selected, you can use this technique to hide 2nd table visual.

Just an idea.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

[Mariusz]

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]

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

Request you to please describe.

Thanks...

[Mariusz]

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

[parry2k]

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

[amitchandak]

@Anonymous , you can change the content of the measure . So you have two kinds of fields and do it.

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115

Or use the bookmark to Switch table

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive