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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Supriya
Frequent Visitor

Single line chart with multiple types of data

Hello All,

 

I have a scenario where I have a column in a table which is having multiple projectlist.

And each project is of different type.

And the types are for ex FP and T&M.

1.PNG

 

Now as we can see in above image , Charge Ratio is showing for FP type Projects.

 

This Image shows Bill Utilization for T & M  Projects.This Image shows Bill Utilization for T & M Projects.

 and Second Image showing Bill Utilization for T&M Projects.

 

My Requriment is ,I want to show both The Charge Ratio and Bill Utilization in One Visual According to the Project Type.

I have a slicer which user can choose the projects.

If the choosen project is T&M type then it should show visual according to that type.

If it is FP then in that line chart only, i would like to show the visuals according to that type.

 

Note:- I dont want to use the slicer for TYPE selection

 

Any suggestions.

 

Supriya D

1 REPLY 1
Greg_Deckler
Super User
Super User

I'm not getting it, can you try explaining it again?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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