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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Aproksymacja
New Member

Proper Filter Plot for Index

HI!
I want to calculate an index in Power BI. I have this measure: Index_EUR_GALLON = DIVIDE( 'Fixed Formulas & Ingredient & Price'[Product_Price_EUR_GALLON], CALCULATE( 'Fixed Formulas & Ingredient & Price'[Product_Price_EUR_GALLON], FILTER( ALL('Fixed Formulas & Ingredient & Price'[Date]), 'Fixed Formulas & Ingredient & Price'[Date] = SELECTEDVALUE('Calendar'[MonthlyDate]) )) where

Product_Price_EUR_GALLON = SUMX( 'Fixed Formulas & Ingredient & Price','Fixed Formulas & Ingredient & Price'[LFA_Ingredient.Mass_Rate]*'Fixed Formulas & Ingredient & Price'[Price_EUR_GALLON])

Index is calculated properly.

 

When I want to plot the results I have line plot where on x axis I have 'Fixed Formulas & Ingredient & Price'[Date] on y I have calcuated Index. Table 'Fixed Formulas & Ingredient & Price'[Date] contains also column FormulaStartDate which informs us which formula was applied for which date.

Example. Product: [a,a,a,a,a,a,a,a,a], Date: [2020-01-01,2020-02-01,2020-03-01,2020-04-01,2020-05-01,2020-06-01,2020-07-01,2020-08-01,2020-09-01], formula: [1,1,1,1,1,3,3,3,3] FormulaStartDate:[2019-11-01,2019-11-01,2019-11-01,2019-11-01,2019-11-01, 2020-06-01,,2020-06-01,2020-06-01,2020-06-01]

 

I have two slicers one to select Baseline Date for Index, second to be able to see on the plot only values for one formula.   

When my baseline date is Jan2020 (I have seected based on ('Calendar'[MonthlyDate]) and when I filter FormulaStartDate using slicer to see on the plot dates assigned for FormulaStartDate 2020-06-01, nothing shows up.
I guess that's because we filtered out our baseline date.
How to solve this issue?

1 REPLY 1
foodd
Super User
Super User

This reply is informational. Please follow the decorum of the Community Forum when asking a question.

Please share your work-in-progress Power BI Desktop file (with sensitive information removed) and any source files in Excel format that fully address your issue or question in a usable format (not as a screenshot). You can upload these files to a cloud storage service such as OneDrive, Google Drive, Dropbox, or to a Github repository, and then provide the file's URL.

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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.