cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

fixed values in the graph

Hello

 

I have a document that I need to see the daily fixed values, but when I put in the graph the power bi always sums everything up, I want a function for it to show me the same fixed values in the table. My table has the name of the stock, stock price and date, each day has a different price.

 

And I also need a function to know the share price on the first day and the last day of any year.

 

If anyone can help me I'll be grateful, sorry for the simple questions, I'm a newbie in power bi.


Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Frequent Visitor

Re: fixed values in the graph

To remove summation for any graphs,in the value feild,click the dropdown and choose the value option to anything else other than sum or summarize.

 

For First day and last day price of a year.Considering you have two filters one for year and other one for stock item.

 

You can create 2 measures:

 

1.First_day_price=calculate(sum(stockprice column),filter(tablename,stockdate=min(stockdatecolumn)))

 

2.Last_day_price=calculate(sum(stockprice column),filter(tablename,stockdate=max(stockdatecolumn)))

You can create 2 score cards for the above 2 measures

So when you select the respective year and stock items in your filter the score cards will show the stock proce for those filter

View solution in original post

2 REPLIES 2
Highlighted
Frequent Visitor

Re: fixed values in the graph

To remove summation for any graphs,in the value feild,click the dropdown and choose the value option to anything else other than sum or summarize.

 

For First day and last day price of a year.Considering you have two filters one for year and other one for stock item.

 

You can create 2 measures:

 

1.First_day_price=calculate(sum(stockprice column),filter(tablename,stockdate=min(stockdatecolumn)))

 

2.Last_day_price=calculate(sum(stockprice column),filter(tablename,stockdate=max(stockdatecolumn)))

You can create 2 score cards for the above 2 measures

So when you select the respective year and stock items in your filter the score cards will show the stock proce for those filter

View solution in original post

Highlighted
Helper I
Helper I

Re: fixed values in the graph

Thank you

Problem solved.

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors