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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
adam12asu
Regular Visitor

cleaning data, by creating measures. unable to use measures in charts and graphs

I am new to PowerBI and thought i had flexibility to import my powershell script via powerbi's api-which works..but in the process I do not have access to the MODELING tab, and all the flexibity that, that allows. Instead i have tried cleaning up data, by creating measures. i am now unable to use those measures in my axis for charts and graphs.

 

Is there a way to take a measure and use it in a chart? For example I had a column for data and time. I removed time in the Measure, and now i want show the historical performance of an item just using the date.

2 REPLIES 2
Greg_Deckler
Community Champion
Community Champion

OK, trying to understand what you are doing here. You are saying that you created a data model using the Power BI api now you are working with it in the Service? Currently, you cannot edit or change the data model in the Service. Then are you saying that you connected Live to the Power BI data model in the Desktop and created measures? I'm confused by your process. 

 

Typically when people start out, they use the Desktop and import data, create their data model with calculated columns and measures and often reports and then publish to the Service. That is probably, by far, the most common use case. Then the second most common is using Power BI Desktop to connect to a source via Direct Query. You can do certain things only in the Service but you will be highly limited when it comes to data modeling. 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Sorry for the confusion. I used Desktop to create the reports. While in Desktop i realized that, unlike using a database, with my powershell data i was unable to use the Modeling tab to format the data columns as desired-all the values are grayed out. That is when i created the measures to get the desired values in each column.

 

Right now, I have fields for Date & URL, then a few numerical values for URL performance. The URL and Date our measures i created to remove unwanted data from each field...now i am trying to figure out how to use those  measures to display my data.

 

I guess my question is do i need to clean the data prior to getting it into PowerBi desktop, or is there a way to allow those measures to be used in the axis of a chart, for example.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors