Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
birenpat
Regular Visitor

Need help for calculating YTD based on slicer selection for few columns

Hi

Below is the table which I want to achieve based on month selection from a dropdown slicer .

 

I have got mainly one issues here as below:

1) Here I have got lots of columns such as Avaliability, Outage Minutes, Sev1 MTTR etc etc... But then I have got Month data and YTD data on rows. The difficulty is how can I create this table where it will show YTD and Month data on row for each of the column and also the data needs to show as below

a) For Month, based on the selected month from the dropdown list , it will show  data for that month

b) For YTD, based on the selected month from the dropdown list , it will add up  data from January to that selected month and show on that row

 

I am bit new here and also still learning PowerBI, so appreciate if anyone could help explaining what I need to do to achieve this. It looks bit complex for me. Appreciate for a quick reply.

 

birenpat_0-1704186588241.png

 

 

birenpat_0-1704185426253.png

 

4 REPLIES 4
birenpat
Regular Visitor

Hi @MFelix ,

 

Thanks for your reply.

 

Do you mean to create a measure something like

Outage-Measure-MTH

Degradation-Measure-MTH

Sev1-MTTR-Measure-MTH

Sev2-MTTR-Measure-MTH

....

Outage-Measure-YTD

Degradation-Measure-YTD

Sev1-MTTR-Measure-YTD

Sev2-MTTR-Measure-YTD

 

Then try put them in matrix?

 

I tried the above way, but it doesn't help as need to create one measure for each column.

Is there any way I can create only two measures, one for MTD and another for YTD for all columns? 

 

Regards

Biren

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Hi,

I messaged you privately, pls check

MFelix
Super User
Super User

Hi @birenpat ,

 

If you create a measure for each of the values (month and YTD) and then add it to the matrix and select the option switch values to rows you will present the visualization has you need.

 

MFelix_0-1704272480242.pngMFelix_1-1704272508058.png

 

 

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.