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.
Hello,
We want to display the number of suppliers that fall within a certain spend range over the period selected via timeline slider. Below shows a chart for Apr - Mar financial year with suppliers per spend range
However the values are inflated because power bi is calculating the number of suppliers at a monthly level. So if say there were 100 unique suppliers in month one and 10 unique in month 2 etc, it's summing those can't per range. What we would like is to calculated the number of suppliers per spend range over the entire period (in this case one year). Any help would be appreciated.
Solved! Go to Solution.
In this scenario, you already put the "bucket" field on X-axis. If you need to split the data into monthly level, you can only put month field on Legend so that it will show monthly data under each bucket.
Regards,
In this scenario, you already put the "bucket" field on X-axis. If you need to split the data into monthly level, you can only put month field on Legend so that it will show monthly data under each bucket.
Regards,
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 |