Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
…like I would format the same value to display a certain number of decimals point. Using Direct Query so the model can’t be altered.
Solved! Go to Solution.
Hi jahall4,
We could also change the data type in the report view, in Report View, select the Gauge Visual, then choose the value in the Fields, under Modeling tab, there would also be the Data type available to modify:
As as you could see, if only for the column data, Gauge would just display the the sum of the column, so if you would like to have a percentage displayed, we need to create a measure ( filter some special data from the data range, then divide it with the total. Or, we need a slicer visual to help showing the proper precentage) and then put the measure into Gauge Visual.
Please reply back if any further assistance needed.
Regards
Hi jahall4,
We could also change the data type in the report view, in Report View, select the Gauge Visual, then choose the value in the Fields, under Modeling tab, there would also be the Data type available to modify:
As as you could see, if only for the column data, Gauge would just display the the sum of the column, so if you would like to have a percentage displayed, we need to create a measure ( filter some special data from the data range, then divide it with the total. Or, we need a slicer visual to help showing the proper precentage) and then put the measure into Gauge Visual.
Please reply back if any further assistance needed.
Regards
Thanks Michael,
This was a "buger" to find. I kept looking for this as part of the Gauge Visual's properties since you can format there for decimal places. I guess I'm expecting too much continuity for such a young product.
Note: I think on the report this is the only way it can be done because we are using Direct Query
There does not seem to be any way to achieve this with a Direct Query. I hav ethe same issue with the Power BI gauge on a report connected LIVE to a multi-dimensional cube. The calculated measure in the cube is formated as "Percent" however
Ideally the gauge picks up and uses the formatting defined on the multi-dimensional model for a live connection - currently the gauge does not do this.
There seems to be an issue with some built-in visualizations in Power BI when it comes to % measures in a SSAS MD Cube. i.e.:
This issue is present in Power BI Desktop "March 2018" version as well as the March 2018 release of PBIRS (Power BI Report Server).
It means that in order to prevent confusing users I need to avoid using rich visualisations for % values and keep these corralled in either a table or a matrix viausalisation 😞
@jahall4 In power bi destop under Modelling tab, highlight your value column and click on '%' icon under formatting.
The UI you have screen shot (best I can tell because of the pixelisation) is not avaible to me. Looks like maybe you are working in the model? Is your data source Direct Query?
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |