Forum Discussion
Power BI Matrix Viz Dispay help
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 |
4 Replies
- v-gizhi-msft
Community Support
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
- v-gizhi-msft
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
