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
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
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.