Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I am pretty new to power Bi and struggling with a report bild.
we are working with our client on building a report. and we have created a table visual which displays data in below format
product | planner (group by) | Stock coverage(Measure) |
Prod A | first | Understock |
Prod B | first | Understock |
Prod C | first | Optimal stock |
Prod D | first | Optimal stock |
Prod E | other | Overstock |
Now product column is column coming from product table, and planner(group by) we have a created a group based on the planner in the same table.. We have then created a measure (stock coverage) based on the stock available to see if it is understock or overstock.
Now user wants to see for the planner how many products are overstock and understock etc. output like below
Planner | Understock | Optimal Stock | Overstock |
First | 2 | 2 | 0 |
Other | 0 | 0 | 1 |
But we cannot use a measure in a column matrix. and not sure how to get the data in required format. Any leads.
Hi @Anonymous ,
Since you can use columns in the matrix, i would suggest you to create a new column based on the measure.
No other way of doing it? Since user had already created the measure to calculate the stock coverage (it is little complex). i was thinking to find a way to use the measure itself and try to convert the measure to calculated columns. Will give a try by converting the measures into the calculated columns and see if it works out
@Anonymous you can simply reference the measure in the new column
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
26 | |
10 | |
10 | |
9 | |
6 |