Forum Discussion
Help building a calculation or Point me in a Direction
Hi jsnrchtr ,
Please provide sample PBIX file and show the expected outcome based on the sample data .
Thanks
The arrows are moving, but I'm waiting on the data to change again to confirm. I should know tomorrow as I just updated data that will reflect tomorrow in the cloud. The issue I'm having though is the arrows (with the exception of the one item that is "0" and a dash) are all changing at the same time. If Unit A goes down by 1, all unit arrows reflect the change vs. just that unit. I have each card filtered by unit but it is as if its ignoring the filter. I'm having that issue with a few cards on the dashboard I think and I'm not sure why it is choosing to filter some cards but not all cards.
Community SupportHi jsnrchtr ,
As per your requirement, i have updated the code.
If this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.
- v-dineshya
Hi @jsnrchtr ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Thank you.
- v-dineshya
Hi @jsnrchtr ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Thank you.
Adjusted the formulas as supplied. Made one change for the arrows... > 0 Green , < 0 Red.
All arrows are still moving at the same time and still seem to only be refreshing the first time data comes in. When the dashboard refreshes, the arrows ignore the new data. I'll verify again tomorrow morning when the dashboard will have new data changes (The source only updates once daily and I don't control the source). I am still also getting strange slicer behavior. If I click on a single unit, my completion percentage card reflects odd numbers. Total number is accurate. If i filter by a unit, that completion percentage instead of showing that units completion percentage, ballons to over 200% in some cases.
- v-dineshya
Hi jsnrchtr ,
Please provide sample PBIX file and show the expected outcome based on the sample data .
Thanks
- v-dineshya
Hi @jsnrchtr ,
We haven’t heard from you on the last response and I had earlier requested a sample PBIX file based on your above reponse.
In line with our community guidelines, we may close this thread if there's no response, but you're always welcome to create a new post if needed.If you need further clarification or continue to face issues, feel free to reply we're here to help!
Thank you for being an active member of the Microsoft Fabric Community!
Regards,
Dinesh