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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Can we show data for one year and 5 years in same table visual.

ID, name, measure 2, measure 3 and indicator are coming from one dataset(having one year of data) , date(xyz date not calendar date) is coming from one dataflow and measure 1 is coming from ssas tabular model(having 5 years of data with same tables).
Can we show data for one year and 5 years in same table visual. If i select one year (e.g current year in date slicer) it should display 5 years of data for measure 1 and one year(current year) data for measure 2, 3

Example as shown below:

Sarvina_Sawant_0-1674459142719.png

 

 

1 REPLY 1
Anonymous
Not applicable

What dax calculation should I use for measure1 and how do I relate table(measure 1) with date table. 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

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.