Forum Discussion
josephliverpool
2 years agoFrequent Visitor
Changing from old card viz to new card causing errors
Hi! I hope someone can help. I have some data in the old car visual in the measure below: # Completed Rate % = VAR CountWon = SUM(table1[Count if completed before meeting) VAR CountConclud...
- 2 years ago
Hi josephliverpool ,
Do you have any conditional formatting on the original visual?
I tried recreating the error but it worked fine:
I'm assuming the random ' in the example is just a typo:
SUM(table1'[Total Matters completed])If the visaul treated the measure as wrapped in " or ' that could explain it 🤔
josephliverpool
2 years agoFrequent Visitor
I could absolutely kick myself. It's a template and whoever set it up, the old card had black text, the new card has been setup with values coloured white which is why they didn't show up!
Thank you!!!
SamWiseOwl
Super User
2 years agoI think you created the solution not me, well done for figuring it out!
Templates have caught me out a few times.
Have you tried the incremental refresh feature in templates? Tells Power BI not to refresh data past a cetrain age which is handy.
- josephliverpool2 years agoFrequent VisitorAh no not tried it, I'll give it a go!