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.
Is there any way to show text in a card? I only see the ability to count with text data
My data set uses UP or DOWN to show trends for YoY and Linked periods.
Another way is to create a table (in the Query Editor) with two columns, one with the variable data and one with the fixed text.
For example, I needed to display the last refresh date of a report, so I created this single-row table:
= #table(type table[Date Last Refreshed=datetime, FixedText=text], {{DateTime.LocalNow(), "Last Refresh:"}})
and then, in the report, I added a multi-row card with the two columns.
Another possibility is to use a measure in the table instead of the fixed text column, but I guess it's the same effort for the developer and for PBI to display...
Measures can return text.
You could do something like:
MyTextMeasure = IF( [YOY%] > 0 ,"UP" ,"DOWN" )
A feature I did not think was possible, this is something that will be so valuable to me!
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |