Drill through dynamically change to another drill through report based on value clicked on

[DebbieE]

Say I have he following data (Just an example)

Date                       ID        Cost          Item

11/11/2018            1          50.00        Descr 1

11/11/2018            2          90.00        Descr 2 

12/11/2018            3          9.99          Descr 3

13/11/2018            4          20.00        Descr 4

13/11/2018            5          40.00        Descr 5

And you have a clustered column chart showing these figures.

Date on Axis Cost in Value

with a drill through to the underlying data (Above) based on Date

However, if the value is below 100.00 I dont want them to see anything so I want them to see a report saying the value is too low. Please choose a category with a value of over £100.00

Is there any way I can actually do this, send them to different reports based on the SUM(Cost) ?

Thanks in advance

[v-piga-msft]

Hi @DebbieE,

I'm a little confused about your requirement. 

Do you want to show the visual based on the category the sum of cost >=100 and the sum of the cost <100?

If it is, you could create a calculated column or a measure  with the formula below and then drag it to the visual level filer.

Column = IF(CALCULATE(SUM(Table1[Cost ]))>=100,">100","<100")

If I misunderstood, please describe your requirement in more details.

Best  Regards,

Cherry

[DebbieE]

No thats not what I was wanting.

I have he following data (Just an example)

Date                       ID        Cost          Item

11/11/2018            1          50.00        Descr 1

11/11/2018            2          90.00        Descr 2 

12/11/2018            3          9.99          Descr 3

13/11/2018            4          20.00        Descr 4

13/11/2018            5          40.00        Descr 5

And you have a clustered column chart showing these figures on your top level report page.

Date on Axis Cost in Value

with a drill through to the underlying data (Above) based on Date to the underlying page

However, if the value is below 100.00 I dont want them to go through to the drill through report. I want them to see another report page just saying 'the value is too low. Please choose a category with a value of over £100.00'

Is there any way I can actually do this, send them to different reports based on the SUM(Cost) ?