Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Here is my Count Visual
Here is my Count +0 Visual
I have been trying to solve this for months. On the Count + 0 visual the issue is that the customer selected started 7/1/22. How can not show the 0 months prior to Jul 2022?
I can not find a sample report to help me solve this.
I some how need use the Start Date for each company it seems. So when companies are selected by Slicer, the Month Year starts showng months from their Start Date Month.
Solved! Go to Solution.
It's way more complicated for my model, so I moved on.
Hi @bdehning ,
Thanks for the reply from Ashish_Mathur , Musadev .
After many days, has your problem been solved?
Was my answer helpful? Was there a test performed?
I would be grateful if you could provide me with sample data for testing, please remove any sensitive data in advance.
If you have any further questions please feel free to contact me.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
It's way more complicated for my model, so I moved on.
Hi @bdehning ,
You need to create a new measure to dynamically calculate the "Count of Total Gross Incurred" from the Start Date of the selected company.
Count of Total Gross Incurred =
CALCULATE(
COUNT(LossRun[Total Gross Incurred]), FILTER(
FILTER(
ALL('DateTable'), 'DateTable'[Date])
'DateTable'[Date] >= MIN(Companies[StartDate])
)
)
I would be grateful if you could provide me with sample data with the personal information erased.
If you have any further questions please feel free to contact me.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
in the Filters Views, Uncheck the Null (blank) option for this visual so it will not show the blank rows.
You have more dates in the table than the dates you are using for calculations. You have this issue, add the dates to X-axis from the table you are using the values or check the dim_dates table and keep only the dates you have in your FCt table.
That is not an option as I use
Hi,
Share the download link of the PBI file.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
89 | |
84 | |
76 | |
64 |
User | Count |
---|---|
136 | |
111 | |
98 | |
97 | |
92 |