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

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
Anonymous
Not applicable

Set variable at page load time

I need to modify the use of a measure or how it's source items are decided dependent on the page or visualization currently executing. If I'm on page 1, the stack chart is based on weeks, page 2 months, page 3 Quarters. So If on page 2 set measure = to the weeks_measure. If I can get something set I can vary my functions and aviod having duplicated calculated columns or measures based on page. Any Ideas?

1 REPLY 1
Pragati11
Super User
Super User

Hi @Anonymous ,

 

Not sure on I understand your requirement clearly. Please share some screenshots around your requirement.

 

Looks like you have created 3 different tabs one for MONTHS, one for WEEKS, one for QUARTERS.

You can use a date hierarchy which will give you all levels from YEAR, QUARTER, WEEK, MONTH, DAY on a single tab.

 

Please elaborate with some screesnhots to suggest better solution.

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Helpful resources

Announcements
FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.