The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi team,
@Greg_Deckler @amitchandak @Ritaf1983 @johnt75 @PaulDBrown @sevenhills @Ahmedx
I'm working on requirement where it has two years year1 and year2
Now if I select year 2023, then the corresponding year2 will appear i.e., 2023,2024,2025,2026,2027.
So my requriement is like, for example If I select 2023 in year1 slicer then my title should change dynamically based on year2. In short my dyamic title for the visual should be "Assumption years are 2023-2027"
Can anyone helpme out with this. Thanks a lot!!
Solved! Go to Solution.
Hi @Usha_pk
You can create a measure
Title = "Assumption years are " & min('year1'([year])) & "-" & max('year2'[year]))
and put it on the title with conditional formatting
If this post helps, then please consider Accepting it as the solution to help the other
members find it more quickly
Hi @Usha_pk
You can create a measure
Title = "Assumption years are " & min('year1'([year])) & "-" & max('year2'[year]))
and put it on the title with conditional formatting
If this post helps, then please consider Accepting it as the solution to help the other
members find it more quickly
@Usha_pk
Glad to help 🙂