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
1) i have a plan dates of Start and Finish for my project activities.
2) i have 2 files. revision1 and 2.
3) want to compare how much these 2 files different.
4) which visualization would be pefect to analyze the data??
I have a report to see schedule duration using one of them.
but this visulation only put one date in Start date and finish date...?
any good idea?
thanks,
Hi @colourfullife ,
According to your description, my understanding is that you want to mark the items which are different between versions in the visual, actually, many visual can do that, it depends on your requirement.
We can use a matrix to display it:
Assume that we have two tables like below:
Then we can create two measure to judge if the data is different:
Measure = IF(MIN(version1[Finish])<>MIN(version2[Finish]),1,0) Measure 2 = IF(MIN(version1[Start]) <> MIN(version2[Start]),1,0)
The we can drag the data fields to matrix, then set the conditional formatting for the matrix visual:
The result will like below:
Best Regards,
Teige
thanks very much. could you please share the file that you created?
Also, Is there any way to use this visulization to do same activity that you did?
thanks,
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |