Categories
Advanced/dynamic filtering in OAC
I want to be able to select a Manufacturer in the dashboard filter and the manufacturer column to only show the selected value and for the rest to be blank.
So if I were to select 'FIAT' in the filter the Manufacturer column would present how the FIAT column is preseneting.
I have tried putting a case when into the dashboard filter but I cant get it working, is there a way to do this?
Answers
-
This use case is a bit unique; I'm trying to understand why there would be an additional column a specific manufacturer, versus leaving that column for Fiat out altogether.
If you remove the Fiat column, the Table with the Dashboard Filter would behave as you expect.If the Fiat column is indeed needed, could you try a Pivot Table instead of a Table? (I'm not sure if this will work, but worth a shot)
In the grammar panel for the Pivot Table, try:
Columns: Fiat (plus any additional attributes)
Rows: Manufacturer
Values: Repat Volume1 -
Hi Jamie,
Its for our sales team, if they are meeting a certain manufacturer they want to be able to select the their name in the filter which will visually blank out the names of the other manufacturers but show their rows and sales.
The FIAT column is what id ideally like the first column to look like if FIAT was selected in the filter.
What currently happens is it will filter to just that specific row. I think PowerBI has the 'Selectedvalue' function which does this.
0 -
@LukePa So what happens if you just remove the FIAT column?
Like this (pretend Ace Supplies says Fiat in the Manufacturer attribute):
0 -
Apologies, I don't think my above solution captures the spirit of what you're asking for.
I believe you essentially want to be able to see all of the other Repat Volume values but not the other manufacturer names on-screen when a specific Manufacturer like Fiat (or Ace Supplies in my example) is selected from the Dashboard Filter.
It's not exactly what you had in mind, but I have a workaround.
You will have 3 visualizations:- Dashboard Filter
- Tile
- Table
Dashboard Filter:
Tile:
Table:
Once those visualizations are created:
Table:
Right-click Manufacturer in the Rows area and select Hide.
Dashboard Filter:
Deselect the checkbox that references the Tile viz under "Apply this Filter to".
(I renamed the Title of my visualizations to convey this):
You can upload the .dva I used by unzipping the attached file and loading it into your environment:
0 -
Thanks for the help, unforutnaley they want the Manufacturer column to not be hidden, for example when 'Ace Suppliers' is selected Ace would show and the rest of the manufacturers would have blank columns.
I dont think this is possible though.
0
