Visualisation (Slicer and Button Slicer)
Hi everyone, I hope you all have a nice day. I want to ask (pictures attached), I gave an example of me using visualisation of "Button Slicer (Top)" and "Slicer (Bottom)" in the picture, I have a table where I have Reporting Date column then I make custom column for the quarters and months. The "Year" in the slicer is from Reporting Date hieararchy (Year), but the quarter and month in the slicer, they both are custom column that I made from the Reporting Date column (so they are not the hieararchy of "Reporting Date"). My questions (I don't mind if you answer with "Slicer" visualisation or "Button Slicer" visualisation): In Picture 1, If I select Q1 and it turns grey, how do the visualisation slicer for months turns black (for Jan, Feb, Mar) without me selecting the Quarter slicer? In Picture 2, If I select any month (for example: Aug) and it turns black, how do the visualisation slicer for quarter turns grey (Q2) without me selecting the Quarter slicer? In Picture 3, If I select Year "2025" and it turns black, how do the visualisation slicer for quarter and months also turns black without me selecting Quarter and Month slicer? Please kindly help me answer my questions. Thank you in advance. God bless. ππ
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
Visuals not displaying any data
Hello everyone, I've built a report that is to be used to summarise various economic data. I have been trying to add a slicer into my Power BI report to filter by country across all pages. I had managed to do this, but as soon as I deselected that country and chose another, the visuals wouldn't load. Having deleted the slicer, I cannot revert back either and now all visuals (charts/graphs) that would have been affected by the fitler are now blank. How do I rectify this? - My look clean (None across all pages, 'all' selected on each visual, etc.) - Table mapping of relationships appears correct - Table validation is also okay (e.g. for Italy there is GDP data, it just won't show in the visual) Am I missing something obvious? Thanks in advance!Only show Y-Axis if Splicer selection activated
Hello, I am wondering if there is a way to only show a Y-Axis line on a line and stacked column chart if a Slicer filter is activated. Screenshots below ββ 1. Is the chart when nothing in my slicer is selected (This is where I would like the Y-axis line to not appear) 2. Chart when Bin is selected on slicer (where I would like the Y-axis to then show up) Any help would be greatly appreciated. Thanks! Jeremy B.
[Error] Couldn't load the data for this visual in DirectQuery mode
Hello, we are currently encountering an issue regarding data in the "Direct Query" mode: Within the Slicer: If it's single selection, the visualization chart encounters the following error: [OLE DB or ODBC error: [Expression.Error] Unable to fold the expression to the data source, please try a simpler expression] (as shown in picture below). If it's multi-selection, the visualization chart displays correctly. May I ask what could be the cause of this issue?Filter Columns (Text) by Slicer
Hey guys I have a table with multiple categories and I need to filter them in the visual by slicer. The table should be in one visual with all the data. And if a filter is selected it should filter the columns not the rows/values. Filter Nutzung (filter rows): "Nutzung" that need to be filtered: easy with a typical slicer with the values from the original table. Filter Gewerk (type of work) - Filter columns: there starts the problem there are multiple columns with the same type of work (red is one and green). The prefix to each name in each column is red = "Heizung" = "HEI". For green = "KΓ€lte" = "KAE" Filter Systeme - Filter columns: I assume this would be the same workflow as "Filter Gewerke". I know there could be a workaround on this one and this is not the core of relational databases/modelling with primary keys. I hope you know what my problem/goal is, otherwise let me know - thanks a lot in advance! beste regards, MrNeverlandRelative Data Slicer using Variable
Hello, We have a relative date slicer for months. When we present our visual we use a large touch screen board. I am trying to find a way to add a radio button, drop down, or some other functionality to the relative date. I want the user to be able to select 1,2,3,6, or 12 months instead of typing it in the field (populated with 1 in the iamge below). After much digging online I have not found anything that works. Is this possible, if so how do you do it?
