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.
Does anyone know why I get an incorrect 43%? Oh, data types are:
IsCompliant: Whole Number
Total: Whole Number
Measure2: Percentage of precision 2
2_NumDenom : Text
Thanks!
Solved! Go to Solution.
@Anonymous change the topN filter and manually select the filter value.
Great idea! However, they are both filtered only by the date.
I put those two items in a table and got what I would expect. It appears to be an issue with the card object that shows the 43%.
I went to change the Timeseries_DT filter to basic filtering (which defaulted to the earliest date). I changed to the last date, and it didn't change. That's strange. I poked around and the issue is that most tables have a "Timeseries_DT" field that is the date of every row. Somehow, the % card was pulling from another table's "Timeseries_DT" column. I made it the correct one, and it works!
Thank you for helping me back up and work this issue out!
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 |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |