YOY visualization question

[vrv]

hi all,

I am having difficulties with displaying two diffrent series in the same visualization.

I am trying to have a column chart with the first set based on a global fiilter that picks readings from a table for a date range between Jan 1st current year and the current date and the second set based on a date range between Jan 1st current year - 1 year and current date - 1 year. Namely, two colums will show: the first one whatever the metric is for the current year up to the current date and the second column will show the same etric for the same period the last year.

In my setting, the chart has a monthly breakdown, so I have a column for each month and some partial result for the current month.

For today, for instance, I should see a column for Jan 1st to Jan 31st 2025 next to a column for Jan 1st to Jan 31st 2024, and so forth until the 4th column that shows the metric for April 1st to April 23rd 2025 and the next column April 1st to April 23rd 2024.

The table I am working with has a myDate date filed and a myBitField bit field. The metric I am displaying is a measure:

myMeasure1 =

VAR totalRows = COUNT('myDataSet'[Id])

VAR trueRows =

  CALCULATE (

    COUNTROWS('myDataSet'),

    'myDataSet'[myBitField] = TRUE()

  )

RETURN DIVIDE(trueRows,totalRows)

So, the goal is to have a column chart that displays these percentages for the current year (broken down by month) and for the last year.

Thank you for your help, please let me know if you have any questions.

vrv

[V-yubandi-msft]

Hi @vrv ,

Has your issue been resolved, or do you require any further information? Your feedback is valuable to us. If the solution was effective, please mark it as 'Accepted Solution' to assist other community members experiencing the same issue.

[V-yubandi-msft]

Hi @vrv ,

We haven’t received a response yet and want to ensure the solution met your needs. If you need any further assistance, feel free to reach out we’d be happy to help. If everything is working as expected, kindly mark it as Accepted as solution.

Thank You.

[V-yubandi-msft]

Hi @vrv ,

Has your issue been resolved, or do you require any further information? Your feedback is valuable to us. If the solution was effective, please mark it as 'Accepted Solution' to assist other community members experiencing the same issue.

[vrv]

Sorry,

I have limited experience with the tool as well as with the forum. Let me prepare a dataset.

Thank you for your reply,

vrv 

[V-yubandi-msft]

Hi @vrv ,

Thank you for putting together and sharing the sample dataset.  A big thanks as well to @lbendlin ,  for your ongoing and valuable contributions to the community.

@vrv , have you had a chance to review the PBIX file shared by @lbendlin ? Based on your original question, the solution and explanation provided appear to address your requirements.

If you need any further details or clarification, please don’t hesitate to reach out.

If your issue has been resolved, kindly mark the reply as the Accepted Solution. Doing so will make it easier for other community members facing similar challenges to find helpful guidance.

Regards,

Yugandhar.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[vrv]

ID	myDate(Year)	myDate(Quarter)	myDate(Month)	myDate(Day)	myBitField
1	2024	Q1	Jan	1	1
2	2024	Q1	Jan	2	1
3	2024	Q1	Jan	3	0
4	2024	Q1	Jan	4	0
5	2024	Q1	Jan	5	0
32	2024	Q1	Feb	1	1
33	2024	Q1	Feb	2	0
34	2024	Q1	Feb	3	1
35	2024	Q1	Feb	4	0
36	2024	Q1	Feb	5	0
61	2024	Q1	Mar	1	1
62	2024	Q1	Mar	2	1
63	2024	Q1	Mar	3	0
64	2024	Q1	Mar	4	1
65	2024	Q1	Mar	5	0
92	2024	Q2	Apr	1	1
93	2024	Q2	Apr	2	0
94	2024	Q2	Apr	3	0
95	2024	Q2	Apr	4	1
114	2024	Q2	Apr	23	1
122	2024	Q2	May	1	1
123	2024	Q2	May	2	1
124	2024	Q2	May	3	0
125	2024	Q2	May	4	0
126	2024	Q2	May	5	1
153	2024	Q2	Jun	1	1
154	2024	Q2	Jun	2	1
155	2024	Q2	Jun	3	0
156	2024	Q2	Jun	4	0
157	2024	Q2	Jun	5	1
183	2024	Q3	Jul	1	1
184	2024	Q3	Jul	2	1
185	2024	Q3	Jul	3	1
186	2024	Q3	Jul	4	0
187	2024	Q3	Jul	5	0
214	2024	Q3	Aug	1	1
215	2024	Q3	Aug	2	1
216	2024	Q3	Aug	3	1
217	2024	Q3	Aug	4	0
218	2024	Q3	Aug	5	0
245	2024	Q3	Sep	1	1
246	2024	Q3	Sep	2	1
247	2024	Q3	Sep	3	1
248	2024	Q3	Sep	4	0
249	2024	Q3	Sep	5	0
275	2024	Q4	Oct	1	0
276	2024	Q4	Oct	2	1
277	2024	Q4	Oct	3	1
278	2024	Q4	Oct	4	1
279	2024	Q4	Oct	5	0
306	2024	Q4	Nov	1	0
307	2024	Q4	Nov	2	1
308	2024	Q4	Nov	3	1
309	2024	Q4	Nov	4	1
310	2024	Q4	Nov	5	0
336	2024	Q4	Dec	1	0
337	2024	Q4	Dec	2	0
338	2024	Q4	Dec	3	1
339	2024	Q4	Dec	4	1
340	2024	Q4	Dec	5	1
367	2025	Q1	Jan	1	1
368	2025	Q1	Jan	2	1
369	2025	Q1	Jan	3	1
370	2025	Q1	Jan	4	0
371	2025	Q1	Jan	5	0
429	2025	Q1	Feb	1	1
430	2025	Q1	Feb	2	1
431	2025	Q1	Feb	3	1
432	2025	Q1	Feb	4	0
433	2025	Q1	Feb	5	0
485	2025	Q1	Mar	1	1
486	2025	Q1	Mar	2	1
487	2025	Q1	Mar	3	1
488	2025	Q1	Mar	4	1
489	2025	Q1	Mar	5	0
547	2025	Q2	Apr	1	1
548	2025	Q2	Apr	2	1
549	2025	Q2	Apr	3	1
550	2025	Q2	Apr	4	1
551	2025	Q2	Apr	5	0
552	2025	Q2	Apr	23	1

[lbendlin · Accepted solution]

The attached is only a rough draft.  What you really want is a proper calendar table in your data model.

[vrv]

lbendlin,

thank you for your initial reply, my sample does not want to get into a table. I am still trying to figure out why is the error message saying that it cannot accept more than 20,000 characters when Word says I have 8,000 characters.

The visualization I am looking for is below:

I will try to get a very small sampleand will try again.

Thank you again,

Regards,

vrv