"Programming" filters

[psikonetik]

Hi,

I am designing a report. I want to have at the same time one graph units per day and units per area.

I want to create a slicer where the user will be able to select the kind of product to show on the graphs.

Currently the data table has date|area|nature|units

I want to apply filters configuring them so that I create lets say a slicer value called damaged that when it is clicked only the units with some area and nature values will be selected.

Is this possible without modifying the data table? That would require lot of memory and cpu

Thanks!

[Baskar]

can u please share some sample screen what u exactly want.

That will help me to clear your problem

[psikonetik]

Sorry but I cant snap anything to show it.

I'll try to re-formulate:

I have a datatable with columns date|area|nature|units

I have a barchart with axis x for date, y for units

I want to create a slicer with options: damaged, sellable

so that when I click on damaged the barchart will show the units filtering units with certain area values and nature values and when I click sellable the area and nature values will be different from before.

thx

[Anonymous]

Hi @psikonetik,

We need to know that where the values(damaged and sellable) come from, if the values are included in another table, what is the relationship between your datatable and another table? In other words,  how do you determine if your product is damaged or sellable?

If you don’t want to show actual data of tables due to security policies, you can share us some dummy data of your tables so that we can provide appropriate method for you.

Thanks,
Lydia Zhang

[BetterCallFrank]

You'll need to add a calculated column in your table, which has a formula to calculate whether it is "damaged" or "sellable".

This column/attribute can be put on a slicer, and will frmo there filter your barchart.

Does this help?