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.
Hi DaxTrader,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.
Regards,
Harshitha.
Hi DaxTrader,
I wanted to follow up and see if you have had a chance to review the information that was shared. If you have any additional questions or need further clarification, please don’t hesitate to reach out. I am here to assist with any concerns you might have.
Regards,
Harshitha.