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.
I have a table of MetricName, MetricValue.
Some of these metrics are dollars, others are percents. They are all simply stored as numbers. Is there a way to change individual data point data types, or some sort of clever solution?
One "clever" solution I arrived at was text boxes for dollar signs on the tables that I have. I don't know what to do about the percents though.
@CapnShanty Based on my understanding of your scenario, Did you tried having an another table (Symbols) with MetricName and Symbol.... Link this with your main table on MetricName.... then use the Symbol from Symbols table... Kind off like this.....
Proud to be a PBI Community Champion
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |