Is it possible to use a visualization/slicer, that edits a DAX formula in the Data tab?
Hello, I want to use a slicer in the Reports tab that would allow a user to change a varible that would subsequently change a column formula created in the Data tab. For Example, the below image shows a date slider (let's call this date variable "SlicerDate"). This would be a visualization in the reports tab that any user can interact with. I want to create an IF statement in the Data tab that states, IF(X<SlicerDate, "Earlier", IF(X>SlicerDate, "Later")). Although the actual column formula in the Data tab would not change, the "SlicerDate" within the formula would change according to the date applied to the slicer. The reason for this is there are many people who will view this report themselves and would like to adust the returned variables based on a specific date, but not all people will know how to change data portion of the PBIX file or online file. I want users to be able to change the variable returned in the Data tab without leaving the Reports tab. Any assistance or suggestion is greatly appreciated. Thank you!
Customising slicer with internal subheading. Is it possible?
Howdy all, I'm playing around with page navigation via a slicer and 'Go' button. The pages in my report can be broadly categorised into one of four groups, so I'd like to group these pages together in the slicer under an appropriate heading. It's almost a hierarchical setup, as pictured below, except that one should not be able to select Group 1 (and hence all the contained items) as you can't go to multiple pages at the same time. I have an alternative setup with pop-up buttons, but I'm just exploring other options.
Hyperlink multiple slicers to a link
Dear Team, I have a test link https://powerbi.com/reports/powerbi/Production/testData_abcd and a slicer called "Region" with data: DE, IN, US,... Requirement: if users select a Region option then that value will be added as a tail in the link above. I already found a way with IF formulas: a) RegionSelected = IF(ISFILTERED(Sheet1[Region]),SELECTEDVALUE(Sheet1[Region]),"Select all") b) Formula1= IF([RegionSelected]="Select all","https://powerbi.com/reports/powerbi/Production/testData_abcd","https://powerbi.com/reports/powerbi/Production/testData_abcd?filter=Sheet1/Region eq '"&[RegionSelected]&"'") it meets the request, BUT if we have multiple slicers then I have to create another IF for each slicer and combine all of them in the DAX. It look too lengthy and unprofessional... For example: I have one more slicer called "Component". Another IF have been created as following: c) ComponentSelected = IF(ISFILTERED(Sheet1[Component]),SELECTEDVALUE(Sheet1[Component]),"Select all") d) Formula2 = IF([Formula1]="https://powerbi.com/reports/powerbi/Production/testData_abcd", IF([ComponentSelected]="Select all", [Formula1],[Formula1]&" and Sheet1/Component eq '"&[ComponentSelected]&"'") Question: Do we have another way to sync slicer with a link? Or another concise formula that can solve this problem? Could you please check and support? Thank you.
Count status values based on slicer selected dates duration
Hi Folks, I have a fact table which contains Laptop software installation details like below (attached sample copy), I'm trying to create a DAX expression that will enable me to return data when a Laptop software installation status is in between a selected date range. For example consider InstallationJob- 7989 and LaptopID-8973 Data from below table When i select a date range of 12/01/21 to 03/13/22 using a date slicer, It should be treated as failed Laptop and its count should be in Failed count, If i select slicer from 12/01/21 to 03/14/22, its count should be removed from Failed count and should be added in Installed Laptop as it is installed on 03/14/22 (this laptop no longer a failed laptop after installation done successfully but untill previous date it is a failed laptop). Please let me know if needed more information. note: I have to count them with combination of InstallationId and LaptopId because same laptop may come for software installation in different Installation Jobs (Like LaptopId-3876). The output should be like below as per slicer selection on image Deployed-5 Failed-2 (Installed laptops should be removed) SWError-1 Installed-3 It would be great if we can atleast count only recent record over InstallationId and LaptopId CombinationDate slicer not working (IF value exists on calendar date)
Hi everyone, i need help editing or creating a new measure that evaluates whether a value in on table exists at a particular date within the calender table . I am working with Two tables, on main table that has a customer and a purchase date. The second table is just a table showing the daily calendar dates. the outcome wanted is to evaluate whether a purchase was made by a customer at a certain date on the daily calender.(True,false). and also include their "purchase point" (person which they purchased from). biggest problem: I have implimented a measure to do the above, however when place the measure into a visualization, my date slicer seems to fail in slicing the visualization by date . the measure is as follows: measure = var _cust = MAX(purchase table[customer]) var _date = MAX('calendar table'[Date]) var _temp = CROSSJOIN(SELECTCOLUMNS({_cust},"cust",[Value]),SELECTCOLUMNS({_date},"dt",[Value])) var _date2 = CALCULATE(MAX(purchase table [purchse_date]),TREATAS(_temp,t1[customer], purchase table [purchse_date])) return IF(_date2=BLANK(),"false","true") the relatioinship: the tables are as shown below : The resulting visualization table : this is the table i show in the final visualisation the measure used in this resulting table is: Help needed If anyone could assist me with writing a measure that could make my requirements work so that my date slicer can work with my resulting table id really appreciate it suggestions are welcome:
Slicer Options depending on logged in User
Hi Everyone: I would like a Slicer that I have in one of my pages to expose (or not expose) products from the PRODUCTS Table based on the USER that is logged in from the Power BI service. So, for some USER, some subset of PRODUCTS should be exposed, and for some other USER another subset of PRODUCTS should be exposed. How do I do that? (NOTE: I think RLS won't work for me, because RLS will expose (or not expose) those same PRODCUTS from all other visualizations (other graphics, charts, etc) , that shouldn't be impacted by who is the USER. )Slicer
Hi Power Bi Friends, As you can see, I have a slicer here showing the current financial year 2021 (from July 2020 to Jun 2021) with month to date chart. Question is, how can I show the past data (financial year 2021) if I select the next financial year 2022 slicer. For example, next month will be a new financial year (2022) and the data will be from July 2021 to Jun 2022), so if I select the 2022 slicer, I wanted to show the july 2021 data with previous financial year data for comparison. The end result would be from july 2020 to july 2021.
