Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Solved! Go to Solution.
Hi, @prabhatnath
All you need to do is create a bar chart and put the fields in it to see the number of each species
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @prabhatnath
Maybe you can create a measure to show completion status:
CompletionStatus = IF(NOT(ISBLANK(MAX('ProjectMilestones'[MilestoneName]))), TRUE())
Then put it in Matrix view:
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you @v-yohua-msft for your input. I can see the milestone for each project as per your sample. But I will like to show the output as a graph, may be a Bar Chart or something?
Thanks,
Prabhat
Hi, @prabhatnath
All you need to do is create a bar chart and put the fields in it to see the number of each species
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @prabhatnath ,
If you can modify the query or add a calculated column to your data, you could add a "MilestoneNumeric" column that is a Whole Number format, and equal to the numerical value of the Milestone (MS1=1,MS2=2, etc..)
Then you can create a new measure: MaxMilestone = MAX(Data[MilestoneNumeric])
Finally, a bar chart where the Y axis is your ProjectName, and the X axis is your MaxMilestone measure.
Proud to be a Super User! | |
Thanks @dk_dk for your input.
In Y-Axis it will show the project name, but in x-Axis I want to show all Milestone Names instead of the new numeric column. Can you suggest?
Thanks,
Prabhat
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
82 | |
71 | |
49 |
User | Count |
---|---|
143 | |
121 | |
112 | |
58 | |
57 |