Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

build a new visual based on measure

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 AfirstUnderstock
Prod BfirstUnderstock
Prod CfirstOptimal stock
Prod DfirstOptimal stock
Prod EotherOverstock

 

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

PlannerUnderstockOptimal StockOverstock
First220
Other001

 

But we cannot use a measure in a column matrix. and not sure how to get the data in required format. Any leads.

3 REPLIES 3
APavlovs
Resolver II
Resolver II

Hi @Anonymous ,

 

Since you can use columns in the matrix, i would suggest you to create a new column based on the measure. 

 

 

Anonymous
Not applicable

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

 

APavlovs_0-1629369883816.png

 

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.