Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Recently i ran into a small issue while replicating your Hospital Dashboard,the patient visits growth arrow measure isn’t showing value,it only returned percentage symbol only and not value with percentage,what could lead to this error and what is the solution,thanks
Solved! Go to Solution.
Hi @Diportee97 ,
You can modify this measure.
Patient visit pm =
var _date=DATE(SELECTEDVALUE('Calendar'[Year]),SELECTEDVALUE('Calendar'[Monthnum]),1)
RETURN
CALCULATE([Patient Visits],FILTER(ALL('Hospital ER'),YEAR([Date without time])=YEAR(EOMONTH(_date,-1)) && MONTH([Date without time])=MONTH(EOMONTH(_date,-1)) ))
Then the result is as follows.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Diportee97 ,
You can modify this measure.
Patient visit pm =
var _date=DATE(SELECTEDVALUE('Calendar'[Year]),SELECTEDVALUE('Calendar'[Monthnum]),1)
RETURN
CALCULATE([Patient Visits],FILTER(ALL('Hospital ER'),YEAR([Date without time])=YEAR(EOMONTH(_date,-1)) && MONTH([Date without time])=MONTH(EOMONTH(_date,-1)) ))
Then the result is as follows.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Diportee97
Could you please provide sample data that fully represents your issue or question in a usable format, rather than a screenshot? Ensure the dataset is anonymized and does not contain any sensitive or unrelated information.
Additionally, it would be very helpful if you could share the expected outcome based on the provided data - this can be in any format, including a screenshot. Having a clear reference for comparison will significantly improve the chances of getting the correct solution in the first response.
For best practices, you may find the following links useful:
It seems like Patient Visit Growth
returns blank. Need to see other measures and how they act.
Thanks,
Udit
The expected outcome is that green arrow for Previous Year or Previous Month
Thank you for your concern https://drive.google.com/file/d/1XUNfliNDJtR96SoQUfzB8VGHnL0KZZY4/view?usp=drivesdk
Thats the pbix file for more clarification
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
8 | |
7 |