slicer visualizations

4 Topics

Dynamic Slicer selection of First value based on User Profile
I am trying to get a slicer selection work dynamically based on logged user profile. For E.x if 'User A' has access to "abc, xyz,edf" and "User B" has access to "rft,kjf,qsc", When the "User A" opens the dashboard, Slicer should Select one value from "abc, xyz,edf" value and when "User B" opens the dashboard slicer should select one value from "rft,kjf,qsc". Note: 1. Number of users and values is not fixed. 2. Slicer can select any value based on user Security, no specific order or value. Values User Name abc User A xyz User A edf User A rft User B kjf User B qsc User B
Solved
TK212
3 years ago Place Custom Visuals Development Discussion
1.2KViews
0likes
2Comments
Slicer to create a dynamic visual
HELP please! How can I create a dynamic visual with the details from kWh after tech and have toggles in a slicer column 4 (LED/Controls, Refrig Opt, etc)? I would like to have two visuals, a static one with the details Category and kWh w/o tech and a dynamic visual with Category and kWh after tech , and to be able to change it using a slicer. Many thanks.
Solved
Alexandra_B
4 years ago Place Custom Visuals Development Discussion
985Views
0likes
2Comments
Display the result of a table for a period whose table contains a start date and an end date.
I have a table that contains an id, a start date, an end date: ID Start Date End date 12345 01/02/2021 07/02/2021 67890 01/02/2021 07/02/2021 98765 08/02/2021 14/02/2021 I would like to filter and display the rows for which the period I select in the filter is included in the space between start date and end date. So, for example If the filter is set on period from 01/02 to 07/02, I'll get the lines for IDs 12345 and 67890 ; if the filter is set in period 08/02 to 14/02, I'll get the line for ID 98765; If the filter is set on a period from 02/02 to 05/02 , I'll get also the lines for IDs 12345 and 67890... I know that I can use slicer to select a date period, but it will filter only on one date column and not select the corresponding period... Can you help me to get what I want
Solved
efhache
5 years ago Place Custom Visuals Development Discussion
2.2KViews
0likes
2Comments
Custom Visual Error
While creating two different reports using the same data set and two different slicers brings in inconsistant data. For example, the Hierarchy Slicer brought in the correct percentage rate from the source data, when using the regular slicer - the percentage was off by .11 of the percentage. I had to make all of the slicers the same in each visualization to get the same result. This seems like an error in Power BI with one of the visualizations.
LCarenzo
7 years ago Place Custom Visuals Development Discussion
1.4KViews
0likes
1Comment