2023-09-28

creating a feedbacktracker in sharepoint

 Setting up the SharePoint Issue Tracking app in your SharePoint environment is a breeze. Just make sure to follow these instructions.

  1. Go to your SharePoint environment.
  2. Click on Settings and then Add an app.
  3. Under Apps, scroll down until you see the one called Issue Tracking and then click on it.
  4. Under Adding Issue Tracking, type the name of the list you want to add the app to and then click Create.
  5. Your new app should appear under Lists, Libraries, and Other Apps. Click the name of your app to open it. This will create the basic structure of your app.
  6. Review and change any columns you want by clicking on List and then clicking List Settings.
  7. Click OK to save changes to the Category column. Make sure to review the Priority and Approval columns as well to make sure they suit your needs.
  8. Once you've finished customizing your columns and making other changes, being filling out your list by clicking New Item and then filling out the information for each issue.

liviu

 "bogatii fac bani, saracii fac paduchi"

2023-09-04

parameters in powerbi

 In Power BI, you can use multiple dynamic parameters that filter themselves by creating a cascading parameter or using the "What If" parameter feature. Cascading parameters allow one parameter's selection to influence the available options in another parameter. Here's a step-by-step guide on how to achieve this:

 

1. **Prepare Your Data:**
   Ensure that your data source contains the necessary columns for the parameters and the data you want to filter.

 

2. **Create Your First Parameter:**
   - Go to the "Modeling" tab in Power BI.
   - Click on "New Parameter."
   - Define the first parameter's name, data type, and allowable values. This parameter will serve as the starting point for filtering.

 

3. **Create a Second Parameter (Cascading Parameter):**
   - Click on "New Parameter" again to create your second parameter.
   - Define its name, data type, and allowable values. In the allowable values section, choose "List of values" and use a DAX expression to filter the values based on the selection of the first parameter. For example, if your first parameter is "Category," the DAX expression for the second parameter could be something like:
     ```
     SELECTCOLUMNS(FILTER(YourTable, YourTable[Category] = FirstParameterName), "Subcategory", YourTable[Subcategory])
     ```
     This expression will filter subcategories based on the selected category in the first parameter.

 

4. **Create Visuals and Apply Filters:**
   - Create visuals like tables, charts, or slicers that you want to be filtered by these parameters.
   - For each visual, go to the "Filters" pane and apply the relevant filters using the parameters you created. Use the second parameter to filter the data based on the selection from the first parameter.

 

5. **Test the Dynamic Filtering:**
   - Interact with your report. When you change the selection in the first parameter, the second parameter and associated visuals will dynamically update to reflect the new filter.

 

6. **Repeat for Additional Parameters (Optional):**
   - If you need more cascading parameters, follow the same steps to create additional parameters and set their allowable values based on the selections in the preceding parameters.

 

7. **Publish and Share Your Report:**
   - Once you have set up your dynamic parameters and filters, you can publish your Power BI report to the Power BI Service or export it to share with others.

 

By following these steps, you can create a Power BI report with multiple dynamic parameters that filter themselves based on user selections. This allows for a flexible and interactive data exploration experience in your Power BI reports.