Forum Discussion

DaxTrader's avatar
DaxTrader
New Member
1 year ago
Solved

Converting only chosen rows to %

Hi, using PowerBi for work. New to this but learning by doing!   I import different excel tables via PowerQuery and update the data source every month with new data.  Question: I got a table ...
  • Anonymous's avatar
    Anonymous
    1 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.