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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
klst28
Frequent Visitor

Waterfall chart based on dynamic slicer selectedvalue issue

Hi All, need help here.

 

I'm making a waterfall chart that's dynamic by slicer from two different tables (IndexMRF & IndexMRF COC) with the same structure as below. 

klst28_1-1677467658124.png

& I have slicers for both. 

I want to make waterfall with two of those selected MRF as category. 
klst28_2-1677467807615.png
* Forecast Period on Category is from TableNMI field.

I've tried implementing this code but it's not working.

Selected MRF COC = 
VAR ForecastPeriod1 = SELECTEDVALUE('IndexMRF'[Forecast Period])
VAR ForecastPeriod2 = SELECTEDVALUE('IndexMRF COC'[Forecast Period])

VAR temp_table =
    CALCULATETABLE (
        FILTER (
            'TableNMI',
            TableNMI[Forecast Period] IN {ForecastPeriod1, ForecastPeriod2}
        )
    )
RETURN
    SUMX ( temp_table, TableNMI[Value])

 

klst28_3-1677467884380.png

 

But if I change the variable manually, it works as expected. 
klst28_0-1677467035234.png

Note:

- I disabled the intercations between both IndexMRF with the Waterfall chart. 

- Table relationship:

klst28_4-1677468735800.png

 



Is it not possible to dynamically do this by slicer? Or is my code / setup wrong?
Kindly help to advise.

Thank you. 

 

0 REPLIES 0

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.