Forum Discussion
agraffeo21
10 years agoHelper I
Month to Date
I would like to make a column for Month/Month and Year/Year. I have already done this in excel but it seems that Power Bi will not let me make some numbers in a column percentages, and some decimal numbers. (As seen in my "value" column, I have my value, PCSI, then I have the PCSI MTD/YTD, which were percentages in excel, and are now decimals.)
Is there a way I can make a measurement for Month/Month and Year/Year, still holding the same table format I have? (I must do it with a "value type" column to keep consistency with my date column.)
Thank you.
1 Reply
- v-sihou-msftMicrosoft Employee
In Power BI Desktop, you can't set dynamic format within same column. You can only keep single format for a column. Please vote this idea.
Regards,