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
Heinrich
Post Patron
Post Patron

Power BI Filter Pane - Data Field with a variable

Hello

Can I use a variable in the Data Field within the Filter Pane.

I.e.: the Data Field has a variable (see example) and this variable gets the value from another table/page.

Thank you 

Heinrich

3 REPLIES 3
Heinrich
Post Patron
Post Patron

Hello

Thank you very much.

I tried to make an example.

Hope this helps

Heinrich

End_Data_with_Variable.png

End_Data_with_Variable_Table.png

Heinrich
Post Patron
Post Patron

Hello Charlotte

Hope you are well. As said 

 

one page with the data called KPI's

one page with the time called TIME

 

The KPI have in the visuals a filter called Duration

The TIME have a table with a column "time" with the number i.e. 7

 

The visuals in KPI with the filter Duration is not expressed as a fixed time but as a variable $time

which refers to the page TIME and to the table / column "time"

 

Is that explanatory

 

Heinrich

v-zhangti
Community Support
Community Support

Hi, @Heinrich 

 

Can you provide some sample data or simple pbix files? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures.

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.