cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dhooger
Helper I
Helper I

Formatting a measure in Desktop that comes from SSAS Tabular

I want to format a measure in my PBI Desktop report coming from my SSAS Tabular cube but Formatting is grayed out. For example, I have Sales, which is currency in my cube and displays with two decimals when I bring it in. However, on this table I don't want to show any decimals and normally one clicks on the measure in the Fields area and goes to Modeling in the ribbon and Formatting. But it is not available. I know I can create a new measure in Desktop and then format that but that seems absolutely senseless. For every report, for every measure?

1 ACCEPTED SOLUTION
v-xicai
Community Support
Community Support

Hi @dhooger ,

 

Your demand is a good idea, while it is not supported to format a measure that comes from SSAS Tabular in Power BI currently. You can post your new idea here https://ideas.powerbi.com/forums/265200-power-bi-ideas , to improve the Power BI.

 

It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 

As a workaround, you may set the measure's "Properties" to format the decimal places in SSDT.

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

2 REPLIES 2
v-xicai
Community Support
Community Support

Hi @dhooger ,

 

Your demand is a good idea, while it is not supported to format a measure that comes from SSAS Tabular in Power BI currently. You can post your new idea here https://ideas.powerbi.com/forums/265200-power-bi-ideas , to improve the Power BI.

 

It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 

As a workaround, you may set the measure's "Properties" to format the decimal places in SSDT.

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

So, this is also the case when you make a Power BI Dataset and then make a report from the data set. This forces all reports to be made where the measure has one formatting. But if you need it to be millions in one object and down to the penny in another object, this cannot be done unless you do one of two things:

1) build different PBIX files and publish the same data more than one time.
2) make a metric per data format, like Sales (with pennies), Sales ($ level), Sales (per thousand), Sales (per million)

 

Help. Neither of these really works well for enterprise publishing.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.