Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
@ashraf_SISL1 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!
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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.
@Mariusz What u mean by "what-if parameter table " , we can just create a parameter not table.
Request you to please describe.
Thanks...
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.
@ashraf_SISL1 He means create a table as per the image he showed.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@ashraf_SISL1 , you can change the content of the measure . So you have two kinds of fields and do it.
Or use the bookmark to Switch table
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
User | Count |
---|---|
93 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
112 | |
97 | |
95 | |
64 | |
58 |