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.
I want to show a table in my report and was wondering what is the most efficient way to do this?
can I drag and entire table to the "table visual"? when i start selecting column within a table vizsualization, it summarizes the values... i see how i can select each values properties and select "Don't summarize" but it quite annoying to do this to each column..
is there a more efficient way to show a table in report without items being summarized to begin?
You could set the default summarization to "Do not summarize" in the Modeling area.
but that is still on a column by column basis, correct?
i assume everything was summarized because the columns were all numbers. i assume if i had a string column and selected that first, the rest of the table would come in individual not summarized
Hi @ilcaa72,
@ilcaa72 wrote:
but that is still on a column by column basis, correct?
i assume everything was summarized because the columns were all numbers. i assume if i had a string column and selected that first, the rest of the table would come in individual not summarized
You may need to change default Summaization for each column with number type.
By my test, if you select the column with String type first, the rest column with number type will still be default summarized.
If you have changed the default Summaization of the column with number type to Don't smmarized, it won't be summarized when you drag it to table visualization.
Best Regards,
Cherry
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 |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |