How to Apply Automatic Formatting for Calculation Groups in Deneb, Similar to Power BI Native Visuals

[CSalcedoDataBI]

Is there any way for Deneb to retrieve the correct formatting of a calculation group, just like the native table visual in Power BI does? In the image I’ve attached, you can see how the native visual automatically applies the correct formatting based on the calculation group, whereas Deneb doesn’t seem to achieve this behavior. I’d like to know if there’s a way to replicate this automatic formatting in Deneb so that the values are displayed correctly according to the calculation group.

[PBI-David]

Can you not use selectedmeasureformatstring as an additional column supplied to the dataset?

https://dax.guide/selectedmeasureformatstring/

[CSalcedoDataBI]

Thank you, @PBI-David, for your prompt response. That is an excellent solution, and I frequently use a second column when employing the SWITCH function in DAX to handle multiple metrics. I usually complement this technique with another measure that contains the specific format for each metric, which ensures everything works perfectly.

However, I have noticed that Deneb now automatically retrieves the format when dealing with a measure, which is fantastic as it significantly reduces my workload. In this case, calculation groups work well with that formatting property. Nonetheless, when using the SWITCH function, the original format is lost, making it necessary to include a second SWITCH to reapply the formats correctly.

In summary, I believe this issue could be resolved with the implementation of Field Parameters. As Daniel suggested in this comment, this functionality could address many of these challenges.