Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |