Forum Discussion
Drilling from Chart using Calculation Groups keeps Format for ALL fields on Drill Tab
If someone has already addressed this, please point me in the right direction. I've been searching and haven't found anything that works or is quite the same.
I'm drilling from a chart that is displaying data from a calculation group:
The format string for this calcuation item has been set to give the "min" units:
The problem I'm having is that EVERY numeric value on the drill through page is using this format and has the "min" units. A lot of the measures included on the drill through page are not used in the calculation group, but still include the formatting.
I've tried resetting the calcuation group, but the method I used removed all the filters that needed to be included with the drill through. I've also tried changing the format string expression for the calcuation item to be conditional and only apply this particular format to time value fields. Neither worked.
Is there a way to pass the "default" format for the measure?
Thank you,
William
2 Replies
- v-luwang-msftCommunity Support
Hi WZorn ,
Refer the following article and check if it is helpful.
Combining calculation groups in Power BI to create powerful reports
controlling-format-strings-in-calculation-groups
Wish it is helpful for you!
Best Regards
Lucien
- v-luwang-msftCommunity Support
Hi WZorn ,
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.
Best Regards
Lucien