Forum Discussion
Converting only chosen rows to %
- 1 year ago
if this column is a measure, you can try dynamic format
- Anonymous1 year ago
Hi DaxTrader,
Thank you for reaching out to the Microsoft fabric community forum.
I would also take a moment to thank ryan_mayu , CPCARDOSO , Greg_Deckler , rajendraongole1 for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.In Power BI, column formatting works for the whole column, so there is no direct option to format only a few rows differently. The workaround is to create a measure and use a DAX expression with SWITCH(). This way, if the row is one of those three KPIs, it will show as percentage, and for the rest it will stay as numbers.
So with this approach, values like 0.02 will display as 2%, while the other values remain unchanged
I tested it with sample data, and it worked fine. Please find the attached Pbix for your reference.
Hope this helps if you have any queries we are happy to assist you further.
Best Regards,
Harshitha.
DaxTrader To prevent returning text, use the basics of rajendraongole1 approach as a custom format string for your measure.