Hi All,
I have a source files on csv format (on sharepoint) which contains product list info. of different departmental stores. I combined files onto on source file.
I have a existing running dasbaord and i am dispalying required information to all departmental store- users.
During published on the App, I grantred Permission to all users in each department. They all can view Main Dashbaord online.
Product list is not the part of a main Dashbaord.
I want to create dashbaord 2 for each department and display product list of thier respective department.
Source file is same.
I want each department store can view only their product list only. I am thinking to create department drop down on main Dashbaord so user can select thier department to view only thier departments,
I will grant permision to respective users of each departmnt in thier own Dashbaord.
For eg:
During publish to APP, I will grant or add all XYZ user to the Dashbaord XYZ only. So the will see data from XYZ DB only.
Sample of files as below
| Department Store | Product List |
| XYZ | Round Mouse |
| XYZ | Blue Monitor |
| XYZ | Fantancy Laptop |
| ABC | Yello Monitor |
| ABC | Car Radio |
| DEF | Round Mouse |
| DEF | Car Radio |
| DEF | Apple Laptop |
| IJK | Car Radio |
| IJK | Apple Mac |
| zzz | PC |
| zzz | Game PC |
| zzz | Round Mouse |
Now real help is here:
I have a same source file all secondary Product List Dashbaord.
Can we write DAX command to user can view only thier own dept data? I will use this command on all Prouct List Dashbaord of each dept. store. Just chnage department store name.
help will appreciated.
