cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bezawak
Frequent Visitor

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 NameOverall StatusApproval Type 1Approval Type 2 
 Completed|StatusScheduleDate|Actual Date|IndicatorScheduleDate|Actual Date|Indicator 
Name 21 or  0 if schedule date is null| status is max value of difference of the indicator columndate1|date2|diff of datesdate1|date2|diff of dates 
 
4 REPLIES 4
Microsoft v-gizhi-msft
Microsoft

Re: Power BI Matrix Viz Dispay help

Hi,

 

I am confused about your requirement, and I try to create a sample pbix file:

pbix 

Hope this helps.

 

Best Regards,

Giotto ZHi

bezawak
Frequent Visitor

Re: Power BI Matrix Viz Dispay help

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

 
 
Microsoft v-gizhi-msft
Microsoft

Re: Power BI Matrix Viz Dispay help

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:

132.PNG

Here is my new test pbix file:(I have made a bit changes to original data)

pbix 

 

Best Regards,

Giotto Zhi

bezawak
Frequent Visitor

Re: Power BI Matrix Viz Dispay help

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

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors