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 Every One .
Good Morning I have an issue on how the below format can be acheived in Power BI Matrix viz or another type of viz that could help me resolve the issue ,Below is the layout and any help is much appreciated
Indicator is the difference of between the Schedulde & Actual Dates
Country on rows
Approval Type 1 & 2 in the columns
schedule date & actual date on the values section
Indicator calcualted column -which is diff of dates which will be in values section
Country Name | Overall Status | Approval Type 1 | Approval Type 2 | |
Completed|Status | ScheduleDate|Actual Date|Indicator | ScheduleDate|Actual Date|Indicator | ||
Name 2 | 1 or 0 if schedule date is null| status is max value of difference of the indicator column | date1|date2|diff of dates | date1|date2|diff of dates |
Hi,
I am confused about your requirement, and I try to create a sample pbix file:
Hope this helps.
Best Regards,
Giotto ZHi
Hello Thanks for you file
below is the format
if schedule date is not null and if we have a value for difference then the over all status should be the max of the difference values (Example :max of two like value should be 63,70 ) and overall status should be one column beside country
Hi,
Please try to create this calculated column:
Overall Status = IF('Table'[ScheduleDate]<>BLANK(),CALCULATE(MAX('Table'[Datediff by day]),ALLEXCEPT('Table','Table'[Country Name])))
And it shows:
Here is my new test pbix file:(I have made a bit changes to original data)
Best Regards,
Giotto Zhi
Hello
For me approvals are coming dimension approval
country name from country dimension
actual schedule dates from fact
i have written like this if(scheduledate<>blank()),calculate(max(diffofdates),allexcept(country,countryname)) it throws me an error
and also overallstatus should not get repeated in the layout
Thanks
Kalyana
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 |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |