Forum Discussion
Microsoft Fabric - Column tools
Hi All,
I have a doubt reagarding Microsoft Fabric.
Is it possible to have the Column tools Tab when working with a semantic model?
I would like to select the 'Don't Summarize' in the 'Summarization' option in 'Column tools' because in the charts in my reports need to show the actual values.
I did try to go to the semantic model 'Model view' and go to the 'Properties' pane and have selected 'None' for 'Summarize by' but it is not disabling summarization in my line chart (when Sum is checked, which should be the option when we want to show actual values when summarization is turned off).
Please let me know whether it is possible or not.
Hi, ag91375
Regarding your problem, if your purpose is to display the actual value instead of summary value in the report, you need to set the corresponding columns in the report attempt. The specific operation steps are as follows:
- Power Bi Desktop open your report
- Select your table, click the arrow next to the column in the axis or legend area
- In the pop -up menu, select Do Summarize.
If you do not have this option, it may be because the semantic model processing data will be summarized according to the default settings of the data type. A polymerization field needs to be placed on the axis of the folding diagram. If your column is a digital type or other types that can be automatically aggregated, Power BI will automatically aggregate the column. You can achieve the effect you want in another way. The following is a possible solution:
Process data directly in your report or data view, without relying on the default summary behavior of semantic models. You can try to use DAX formulas in the report to manually control the method of data. For example, you can use the SUMX function to calculate the actual value of each data point.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi, ag91375
Regarding your problem, if your purpose is to display the actual value instead of summary value in the report, you need to set the corresponding columns in the report attempt. The specific operation steps are as follows:
- Power Bi Desktop open your report
- Select your table, click the arrow next to the column in the axis or legend area
- In the pop -up menu, select Do Summarize.
If you do not have this option, it may be because the semantic model processing data will be summarized according to the default settings of the data type. A polymerization field needs to be placed on the axis of the folding diagram. If your column is a digital type or other types that can be automatically aggregated, Power BI will automatically aggregate the column. You can achieve the effect you want in another way. The following is a possible solution:
Process data directly in your report or data view, without relying on the default summary behavior of semantic models. You can try to use DAX formulas in the report to manually control the method of data. For example, you can use the SUMX function to calculate the actual value of each data point.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.