cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Can we have the Matrix(Preview) values formatted?

Hi,

 

Can someone tell me if we can format the values of the Matrix Preview? I  can not find the option to manage Matrix values for  thousands/Million/Billions? Also, do we have the decimal Round off option ?

3 REPLIES 3
Highlighted
Super User IV
Super User IV

Re: Can we have the Matrix(Preview) values formatted?

Hi there,

 

Format of values are values are not part of any visual, it is part of modelling, select you column and then click modelling tab and change the format as required:

 

model.PNG

 

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Frequent Visitor

Re: Can we have the Matrix(Preview) values formatted?

Hi,

 

Thanks for the reply. Well, I am using Live connection for SSAS. At the cube level, we need these values to be shown( Decimal upto 2

eg:23,754.98).

But at the matrix level data, we dont need the small value shown. so, there is no way except modifying at the cube level?

 

Also, what if I am shoing 100,000,000 in the matrix? Dont we have have the option to change the value?

 

Request you to pelase let me know if I can post this as an Idea? I feel, this is very basic thing. Modifying cube level data evrytime over live connection takes 2 business days  for small issues like this. 

Highlighted
Super User IV
Super User IV

Re: Can we have the Matrix(Preview) values formatted?

yes with SSAS you cannot do this, here is another thread on this, 

 

https://community.powerbi.com/t5/Desktop/SSAS-live-connection-formatting-options/td-p/77151






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors