Need a help to Get selected value from slicer in Table View "Table"

[SandeepKumar421]

Hi Concern,

I want to find days passed from date of purchase to selected slicer days. If I am created measure then it is showing total so I want to do this in table. Please help to create this is table and substitute solution for doing.

I want to do find depreciation for item wise, date of purchase less selected days.

 

[Anonymous · Accepted solution]

Thanks for the reply from Ritaf1983 , please allow me to provide another insight:

Hi, @SandeepKumar421 

Firstly, your idea is fantastic! You’ve identified a feature that many community members are eager to implement—the ability for DAX to directly retrieve values from slicers, thereby influencing the generation of calculated columns or tables, as you mentioned in relation to their visibility in Table View.

Nevertheless, according to our measured results, I feel regretful to inform you that it turns out to be a by-design one.

Here is an alternative solution I can offer:

1.Below is my sample data:

2.Next, I created a slicer using the data from the slicer table:

3.I then used the following measure:

diff = 
var selectday=MAX('slicer'[Date])
RETURN DATEDIFF(MAX('main'[Date]),selectday,DAY)

4.The final result is as follows:

5.Of course, you might also consider combining parameters to control the display of columns. Here’s an example link for your reference:

Solved: Tooltip not showng dynamic values in a Bar Chart - Microsoft Fabric Community

Use parameters to visualize variables - Power BI | Microsoft Learn

If you feel that performance needs to be improved, you can also submit an idea on

https://ideas.fabric.microsoft.com/ and wait for users with the same needs as you to vote for you and help you realize the idea as soon as possible. Many features of our current products are designed and upgraded bed on customers’ feedback.  With requirements like this increase, the problem may well be released in the future.

Thanks for your understanding.

Please find the attached pbix relevant to the case.

Best Regards,

Leroy Lu

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

[Ritaf1983]

Hi @SandeepKumar421 

Please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly