Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I am new to PowerBI so sorry if this question seems a bit simple 😉
I have created a table/matrix on the canvass that has "brands" as values.
Then to get the number of sales for each brand (the data is sales transaction based), I put the sales number under the brand value in the Visualisations area. It shows raw numbers, I would rather have them as comma formatted.
Then I add in percentages. I do this by adding the sales again but doing a Quick Calc that summarised count and shown value as Percentage of Grand total.
The % is shown but at 2 decimal places, I want one!
Have found various posts that suggest using the formatting section of the Modelling tab. For me this is greyed out 😞
Was hoping PowerBI was as simple as excel. Where am I going wrong?
Thanks
Andrew
Since modifying this in SSAS doesn't work very well, we need this feature sooner than later.
Reports dsiplay all decimals until manually refreshed. Not sure why that would be.
What is the source, is this a Direct Query connection or import?
You need to have the field selected in the Fields area, not the column in the matrix for the formatting stuff to be active. Also, most of the formatting area is disabled for text.
If you are using the Percent of Grand total I do not believe that you can control the formatting, but you could recreate that functionality as a measure:
m_PGT = SUM(Table[Column])/CALCULATE(SUM(Table[Column]),ALL(Table))
Hi, Thanks for coming back to me so quickly.
The data is brought into PowerBI from a complex SQL Server SQL Query.
The format section of the modelling tab seems to be greyed out for all fields.
Cheers
Andrew
Hi @andrewjmdata,
It seems that you're connecting live to SSAS with Power BI, in which case changing format for a field is not currently supported.
Regards
When will we have formatting options for SSAS Live?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |