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.
Below is simple form of raw data i have, consisting of units sold by quarter. As of now, i am creating a new Table -> Table 2 to get the total of units by quarter, manually useing calculate expression and making cols as per quarter. I also then have few additional cols that i add to this table calulating % etc...
My need is, when i have new data belonging to new quarter Q3, i'll have to go and edit the query and add a column extending the query. Is it possible, that depending on the values of the quarter coloumn, new cols gets added automatically when data for another quarter is available? Some thing like what matrix shows.
Hi,
Simply build a matrix visual and write a calculated field formula to sum up the numeric column.
i want to create a table on which i would then create visualizations of bar charts.
is it possible to create a table from matrix?
Hi,
I do not understand your question.
As mentioned in my query, i am creating table group by type of product, then creating cols with data available for each quarter. (see query screenshot). post this i create additonal cols to this table calulating percentage and other metrics. I then use this table as a source to charts. My question is when i have the data in the next quarter, i'll have to edit this query to incorporate new quarter col. Is there a way i can get this col automatically based on my raw data with whatever distinct quarters are present in quarter col in raw data.
i hope i am able to rephrase my question.
Hi,
Yes. This can be done using the Pivot feature of Power Query. My suggestion is that you do not calculate percentages and other metrics in spare columns - instead you write DAX formulas to do so.
I believe the Matrix visual will do what you seek.
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 |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |