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!
I am comparing Fiscal Year GP %. I created a Fiscal Year Calendar table that looks like this. And I am sorting all my month columns by "FiscalMonthNo". This allows me to compare last year's fiscal year month to this year's fiscal year month.
I also created and added two measured columns to this table:
1) FY2017 Service GP = CALCULATE(SUM('Service GP'[GP]),FILTER('Service GP','Service GP'[Fiscal Year] = "2017"))
2) FY2018 Service GP = CALCULATE(SUM('Service GP'[GP]),FILTER('Service GP','Service GP'[Fiscal Year] = "2018"))
I want to plot the GP % as a line on this chart. Is that possible? Here's a look at my Service GP % column:
if I plot the GP % column as is, I get a "count of GP%:
Hi @JCBI1023,
I think your gp column stored text value, right? If this is a case, I'd like to suggest you convert them to numeric value first.
Current chart not support text value, it will auto summary records by current group.(for text value, it will try to use count or other mode to summary them)
Regards,
Xiaoxin Sheng
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |