Forum Discussion
Create a dynamic slicer name field
Thank you for reply my scenario is
City Table
| Region Code | Region Name |
| DXB | Dubai |
| ABD | Abu Dhabi |
| AJM | Ajman |
| RSK | Ras-Al-Khaima |
| SHJ | Sharjah |
| UMQ | Umm-Quwayn |
| FJH | Fujairah |
FACT Table
| Region Code | Store ID | Store Name |
| DXB | St001 | ABC Plaza |
| DXB | St002 | BCD Plaza |
| DXB | St003 | CBD Plaza |
| ABD | St004 | DEF Plaza |
| ABD | St005 | EFJ Plaza |
| ABD | St006 | FJK Plaza |
now i have two tables
I only want those city names in my fillter which has stores but it should work dynamically, let's say tomorrow they open any store in different region then it should be coming there..
Please support
rgrds
arif
2 Replies
Anonymous , Create a measure from fact(assume two are joined)
Countows('Fact')
and use that in the visual level filter of the slicer of the city and check values is not blank
Hi Anonymous ,
Is below what you need?
If so,create a relationship between the 2 tables as below:
For reference,pls see attached.
Best Regards,
KellyDid I answer your question? Mark my reply as a solution!
