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.
Hi All
I have sales vs target chart it work fine.
I like to remove those target line from May till Dec , because May till Dec no sales yet , so don't need to display.
@Ashish_Mathur have share with me below code , it try to check if SALES_ is not blank , then compute the target line.
TARGET_ = if(ISBLANK([SALES_]),BLANK(),SUM(TARGET_[TARGET]))
Since the sales vs target gap chart is using below expression :-
Paul Yeo
Solved! Go to Solution.
Hello, I downloaded your pbix and replaced the Sales_YTD with this: It works for me
Hi,
I think this is happening because there is no relationship between the Source column of your Target Table and the Source column of your Source table. I tried to create a relationship but could not. Furthermore, i have also simplified some measures. Download the PBI file from here.
Hello, I downloaded your pbix and replaced the Sales_YTD with this: It works for 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 |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |