Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi all
this is a sale report, and i wanted display the sale for each product for each different date period
the current data file does not have this info, so i was wondering if it is possible to add in?
Example date period Jan 15-Mar16 or Dec 16 to Mar17.
any advice is appreciated. Thank in advance
Solved! Go to Solution.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsBased on my understanding, this is what you want to achieve:
Hi @Anonymous ,
Not really sure if I understand your request but have you tried to make the use of the data column on your model and the slicer between dates?
Can you explain a little bit better what is the expected result.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português@MFelix
hihi...as i have many products, so instead of manually using slicer between dates, is there a way to add this date period into the data and then using it as a slicer for the products.
If it cannot be done, i wonder how to using the slicer manually if i need a product to display period between different years?
For example: Dec 16 to Mar17.
Hi @Anonymous ,
What do you mean by date period on your question? Do you want to have a column with the information that a specif product was only solde between Dec 16 and Mar 17?
Or do you want to create some pre definied periods and used them on a slicer?
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThe promotion period is currently not in my data source, so i was wondering if it is possible to add into data source.
But would this then upset the existing file?
Also what format should this date period be, so that it can be used as a slicer later?
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsStarting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
92 | |
87 | |
84 | |
65 | |
49 |
User | Count |
---|---|
140 | |
114 | |
110 | |
59 | |
59 |