Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
1- I need alll the days to show not just where we have values.
2- I need no Blanks or Nulls in any column, need to display the last available data for each of the category (in my case it is combination of Strat, Ticker and Trader).
You can see i tried joining tables and creating measures/ columns to no use.
Note that, max. drawdown and Net Profit column is all i need to present.
Power BI file can be downloaded from the following link:
https://drive.google.com/file/d/1kugJx9Ew478G4gwpzWoIW8BTVeMplnrp/view?usp=sharing
Solved! Go to Solution.
Thank you @lbendlin, it looks good but dates should started from selected Ticker first value. For example for AMD first value is on 23 july 2007, but matrix visual starts from 4 may 07. It should start from 23 July 2007, and all other Ticker values should be 0 if there is no value.
Feel free to update the measure accordingly.
@lbendlin sorry, I don't understand. I want to presents the date starting from selected category from slicer not from the first date available in data.
dates should started from selected Ticker first value.
I don't understand this part. What is "first value" ? Alphabetically or in the order you selected them?
User | Count |
---|---|
91 | |
77 | |
71 | |
65 | |
58 |
User | Count |
---|---|
103 | |
94 | |
75 | |
61 | |
58 |