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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
maverickf17
Helper I
Helper I

Line chart Variations || Need help with wireframe design || Power BI

Hi Team,
The below is the sample snip of the report which i am creating.

maverickf17_1-1757239392561.png


------------------------------------------------------------------------------------
The theme is adventure park cards issued at these parks 
--> The ceo would be intrested in seeing total transactions, current year, last year, variances as shown in the cards.
--> Now suppose say if the variance is decreasing: suppose on year 2025 the ceo might need to see hey which quater and which month for the year 2025 it is decreasing.
----------------------------------------------------------------------------------
Now I need to explore how to map slicers to the legend (Years) of the line chart.
-----------------------
Suppose Ceo selects 2025 on the slicer :2025 qtr with month  should be displayed
suppose Ceo selects 2024  and 2025 on the slicer both the years: qtr with month  should be diosplayed
Suppose Ceo does not select anything on the slicer it should be as last 2 years: qtr with month
---------------------------------------------------------------------------
I need some variations in the line chart 
--> variation 1

maverickf17_2-1757238619776.png

 

--> variation 2

maverickf17_3-1757238671732.png


--> Vraiation3 

maverickf17_4-1757238866376.png

 -----------------------------------
Can someone help me build some variations in Line chart for specifically this use case?
I tried Building but confused and Stuck.
-----------------------------------------

I have attached the pbix file in the below link.
https://www.dropbox.com/scl/fi/nrmsq1ewbz86b1wjejm8h/Cash-Burn-Final-Arjun.pbix?rlkey=piu2nre1zv4nex... 

Please refer page: Line chart variations in the above pbix file after download.
------------------------------------------------------
Thanks,
ARJUN 



1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

1. Don't use Auto Date/Time

2. Don't use CALENDARAUTO

3. Think of the seasonality of your data

 

You already had a meaningful chart, use it.

 

lbendlin_0-1757265339449.png

 

View solution in original post

2 REPLIES 2
v-priyankata
Community Support
Community Support

Hi @maverickf17 

Thank you for reaching out to the Microsoft Fabric Forum Community.
@lbendlin Thanks for your inputs.

I hope the information provided by users was helpful. If you still have questions, please don't hesitate to reach out to the community.

 

 

lbendlin
Super User
Super User

1. Don't use Auto Date/Time

2. Don't use CALENDARAUTO

3. Think of the seasonality of your data

 

You already had a meaningful chart, use it.

 

lbendlin_0-1757265339449.png

 

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors