Setting Default Value of Slicer Checkbox based on role/column?
Hello Team, Its a custom requirement for me, I have a table with ntid and appid with Table 1: ntid appid [email protected] 83 [email protected] 52 [email protected] 72 [email protected] 25 Table 2: I have a mapping table appid and its desctiption for above table. Also i have created a relationship for both the tables. Based on the image attached below while loading the page by default , based on the user([email protected]) logged into the system and the role management is configured properly and that specific users application assigned need to be selected in the slicer check box by default and all the other check box(other user application assigned names(id)) should show with out selected in the screen of slicer. How this is possible to make in Power bi? Thanks and Regards, Siva
Date Range based on Slicer selection
Hello - I'm looking to return a list of the previous "X" days based on a selected day from a slicer. For example, once a day is selected in the 'Date' slicer, I want to return the date range in the visualization for the previous 180 days up to the selected day. In simple words, the logic would be something like the below, but I cannot make it work: IF ( Date >= SELECTEDVALUE ( Date )-180 || Date <= SELECTEDVALUE ( Date ) , Date , blank() ) And then use 'Date' in the visualization and exclude blanks. Any recommendation is more than welcome, thanks!!
Interactive table calculations based off of slicer selection
I'm trying to create a dynamic dataset in Power BI. What i want to do is as far as i am aware not possible in Power BI: I want to set a column in the query table to read in what the slicer has been selected for e.g. my formula in the query would be: 1000* slicer value. this column would then be used by subsequent columns to calculate an output. However as said everything i know about Power BI says you cannot read dynamic data into the query. So what i wanted to do was create a number of measures that create a new table dataset starting from that first point e.g. have a measure running from the slicer to do the initial calculation and then adding measures to that measure to complete the rest of my calculations e.g. i want to replicate the table i would have in the query but in terms of measures.
