Hi, dear PBI experts!
I need to create the chart in PBI with the following inputs:
1) This chart should be the combo chart with bars and line.
2) Bars should be Dates in the format of YearMonths - for example, 2022-Jan, 2022-Feb etc.
3) Line is trend line based on measure selection. As measures I have 2 metrics: 1) distinct count; 2) simple sum.
So in the result it should be something like this:
The problem in PBI is that I can't create the trend line for categorical X-axis in easy way. I surfered for the solution at forum, found several similar ones and implemented it:
But unfortunately I didn't recieve the correct trend line. The result is:
Is anyone could help me to deal with this?
The pbix example with data and formulas you could find here:
https://drive.google.com/drive/folders/1bfnyBf9LTQEJ3C47DpGouF28r9lncRP8?usp=sharing
Thanks in advance!
@Alyona_BI , You can get a continuous axis with Date and Number, Not with a text column.
so YYYYMM can give you a trend not mmm-yyyy
