For example, you could create an instructions section on the page, and overlay multiple text boxes with multiple instructions, all set to transparent text and transparent background. Hi Rajib, Write an additional Message measure, that renders a blank card. Do you have any idea how to fix this? I had a project where I needed the background color of a matrix to be controlled by filters. Power BI is not a mature product and it will take time for it to be fully featured. You might also like to consider using the Filter pane to achieve the same effect. Then in the Icon settings, I selected the fx next to line colour. The filter on the slicer must be different to the filter on the visual for this technique to work. Unfortunately the Map wont disappear with the Check Filtered trick (even if you have a different column slicing on the map, you still have an empty map in view), so the only way to hide the map is to make the card completely cover the map, but if you do that you lose any interactivity with the Map. I have one challenge in our BI reporting. It shouldnt matter that you are using a Table rather than a slicer. See my response to that. Great thanks, JSON . You cant interact with measured filters on cards. In my table data I have a column called Category where there is two items 1) Pump and 2) Reactor. However, that behavior can be changed. CheckMeasure = IF([SelectedName] = "Jason", 1, 0) // checks if Jason is selected The problem with your working is that your chart axis is using the same column of data as your CheckFiltered measure. thanks a lot for your guide. Or maybe create 7 blank cards and control which of them are shown or hidden. Why not just write the DAX so they either show a value, or not. I click on the first bar in graph A, which highlights that bar in graph A, hides my message card and makes a filtered bar graph B visible, while also filtering the table. Yes, its not perfect by any means. Glad this post has been valuable. If you would like me to take a quick look at your workbook, Id be happy to assist. I just downloaded the recent version of PBI. Hi , However, I would have thought that Microsoft would have recognized that a visual (table or matrix)is a complete object in its own right. two tables)? I have tested the behaviour in my Power BI Desktop (Dec 2022), and the Slicer eraser works as expected. Keep an eye out for the buttons. Current v Prior Month = SELECTEDVALUE('Date'[Month Name Short])& " " &SELECTEDVALUE('Date'[Year])&" versus Prior Month". I would like to use different Customer copies one for Sales history and other for Sales table. In order to render the Matrix blank, it is the matrix that needs to be filtered by the Check Filtered measure. Yes, it is definitely possible, but youll need to do some more work. Ive been looking for the solution for quite a while and so glad I have finally found it! My advice is to set up your DAX formulas in a table and test that they do what you want. When I put the Hide Visual into the Filters on this visual, the only option that it will give me is less than and I cant enter any values. Do you have any thoughts? In Power BI Desktop, select Format > Edit interactions. It wasnt working when I used the syntax in your post: Measure =(SELECTEDVALUE(Table'[FY]=FY22) || (SELECTEDVALUE(Table'[FY]=FY23). In the bookmark settings (overflow menu, ) there is an option to have a bookmark alloy to selected visuals, not all visuals. You might find the reply to Rajib above has the answer you seek. Required fields are marked *. Jason is passionate about sharing his knowledge and how Power BI can change lives. Hide Visual = IF( , 1, 0) Hi Vaishnavi, Question, what if you want to do a drill through, rather than a slicer? Power BI adds filter and highlight icons to all of the other visualizations on the report page. ). In the filters of the bar chart I added the hide visual measure and set it to show values when item is 1. Dharanidhar. Each request can have a single or several destinations for a single or several passengers. Format by = Field value If nothing is selected then the message appears over table Bs heading. In the Action settings, I chose Type = Page Navigation, and then selected the fx next to the Destination bucket. The problem is the card becomes transparent but is still considered the object in front, not allowing users to click on the other objects. Nice workaround. For example, selecting a state on a map visualization highlights the column chart and filters the line chart to display only data that applies to that one state. Then I duplicated the table by creating a calculated table like this: It is a one on one copy of the original table. [Check Filtered], The challenge of selectively showing report elements has plagued Power BI report developers for many years now, but there is no out of the box solution for this problem at this point in time. Sales line1 joined with date and customer 1 table Its just coming up as is less than and its frozen. Im glad there is some conditional formatting available. Hi Raj, Planning Year holds the following year. To get this to work youll need two measures: The interaction between [Hide Visual] and [CheckFiltered] can be tricky. If you want to save this guide for the next time you need to Show or Hide a Power BI visual based on selection, you can download the sample workbook here. Now, I am facing issues to completely hide other slicers (Year/Month) based on primary slicer (Interval slicer with value Daily, Monthly, Yearly) selection. Thats just one thought. IF( Hi Mark, button3chart button4table Providing the column you are using on your slicer has a relationship to the data being evaluated by the measure, the values will be evaluated under the context of the selected value. Message) Thats a creative use of this concept. I figured out what was going on. Select the Visual interactions dropdown menu and set Drilling filters other visuals to On. Check Filtered = OR( ISFILTERED(Register[ Grade / Job Title]), ISFILTERED(Register[Region])) To set up the formatting: Hi Brendan, The final requirement is to apply the [Make Transparent] measure to format the background colour of the masking Card. In my example you cant select the visual hidden then shown for the same reason. @JarroVGIT, you're a life saver! My guess is that you have cross filtering set to highlight. Format the chart title text colour with [Hide Labels] Great article, I am uunable to locate ellipses on the right-side of Color on card visual. The Show/Hide needs to be triggered by a different column to the one displayed on the hidden visual. please help I now have a slightly more complex challenge I have a slicer called Year Type which offers two types of calendar Financial Year and Planning Year. But if only one value is selected in the slicer then it should show Current year & previous year Line for the selected value. Power BI does not allow me to set the background conditional formatting (Field Value) to to Make Transparent. If the Card is covering the entire table, you wont be able to interact with the contents of the table, including the scroll bar. I would like to keep graph A showing as a highlighted selection. Hi Sagar, I have successfully used this technique on donut charts without issue. It sounds like everything is working as expected. See the last paragraph in the post: A few final thoughts. Yes, this logic will solve your challenge also. 2. Wonderful idea and smooth execution, thank you for sharing. The issue is the Transparent card is still in front of the matrix until you start interacting with the matrix. Hi Michael, Hi Abu, It is very helpful for my project but when the mask card becomes transparent and matrix shows up, the 2nd row(field value) is not able to be clicked as it is covered by the card. One issue with testing the result of concatenatex over the values function as in your example is that If there are other filters that could be applied, you cant be sure which item will appear first in the array returned by values. Do you have any idea which works the same but with filters? Thank you in Advance. adroll_version = "2.0"; Hope this helps, but my cards are text cards that show the manager name, Dates, employee names and I want to make them hide until the user chose from the slicer a department name, How can I apply this technique to my text cards, Thank you i have found a way and it works. (I am happy because I was bumped out I wasn't able to figure it out in the first place while the answer is not as complicated as I initially thought it would be). You need to make sure it is something that can be sliced by a column of data. If you have any doubts (my model is in portuguese), please, feel free to reach out to me. I am a bit stumped on how to use the SELECTVALUE alternative and then set up the Message card. Maybe you dont even need to hide the visual if ALL is a valid outcome?! I dont know of any way around it using this method. My original issue was actually a slow-performing measure, so I was trying to limit the number of results the matrix had to display. It works OK for my purposes without making the underlying viz disappear. When the wizard pops up, make sure you have the color settings as follows: Id like to only make the second visual appear when either the Y axis description (Sessions) or the Visit are selected. The Message measure goes onto the card, and the card background is formatted with the Make Transparent measure. Then simply turn off the Category Label. HI, everything works great but I want to drill through to additional details from results and it seems to be covered by the card, did I do something wrong with layering or how can I get by this? By default, visualizations on a report page cross-filter and cross-highlight the other visualizations on the page. I came across your question last week and thought about it a bit back then but couldn't think of an approriate answer for you. So, now we explore another issue described by a Power BI user. Hi Eduardo, it is already possible to use expression based formatting to set the background colour of objects. It doesnt have to be a matrix, it could be a pie chart, column chart, or anything that takes at least two field values to display correctly. Of the top of my head, the and effect is caused by the relationships, so you would need disconnected slicer tables. Turn on the drill-down feature by selecting the drill-down icon. As I explained, each request can have multiple destinations, so when we interact with the map, only the line that have that specific destination appears on the table. Are you able to work with an additional column of data within your Territory table, say Territory[Region]? But after adding Hide Visual measure to my Filters on this visual, the drop down does not work. Hi Shannon, So I adapted your approach: I made the background of the grid 100% transparent and then put the treemap background behind it that responded to the filters via DAX formula. Thanks in advance. The Hide Visual measure returns the values 1 or 0 in a card depending on if I click a slicer. Absolutely! This article shows how to use visual interactions in Power BI Desktop. In the end, I reworked my measure (root cause FTW) and now everything is snappy enough to not require hiding the matrix at all. Youll need 4 new measures chart visual Currently there are lots of areas that can do this (including a chart heading) but often it has not been discoverable. This video uses older versions of Power BI Desktop and the Power BI service. I will try to make another report using buttons (which are now primary slicers value) and bookmarks (and will select the one based on UAT). Does this solution still work in the most recent release? can we give condition on power bi visual. If your target visual only requires the one value, and you just want to show or hide that, then skip the Check Filtered steps (skip: Write Check Filtered Measure & Filter Matrix to Render Blank), and just place the Message card over the entirety of the visual you are trying to hide. make the unselected sub-groups more transparent than the selected one. What could be the issue? Hello Jason, Hi Aaron, This meant both my slicers were independent of each other and when either is used it displayed the relevant data on the table visual. i.e If youre using a visual like a Card or Gauge, then you cant slice your values on the visual. Can you help me with my situation where in I have a bar chart for annual revenue with 7 bars by the top 7 clients and I only wish to highlight and display the name of the selected client from a filter, while not revealing the names of the other 6 clients, but showing their revenue stats? Another great article, however I want to be able to hide the entire (table) not Matrix based on the slicer. Would you know why it is not getting applied the filter in visualization filters? Hi Max, Excellent point. I used fiscal month as slicer. Options: I used this to allow for a dynamic axis generated from multiple slicers and a categorical measure. But our users have IE as the default. Use the Edit interactions feature# For the first issue, here are the steps you need to follow: So, a little twitch in the settings solved this issue, but different cases may have different solutions. b. Any tips? However I would like to hide a button according to the return of a measurement, do you think it would be possible? I have visual where I want the table to say 'Current Month vs Last Month' with the month names changing dynamically based on slicer value. You never showed it in your video, but I assume having multiple categories selected would also trigger the transparency? But this method of obscuring both the data and the headers means you can do additional stuff like overlay different types of visuals on top of each other, and trigger a bookmark-like experience from a Slicer, which is very cool (and should be allowed natively). 2. This is amazing thank you. Instead, there is a fx option. Red). I cant figure out why. The || is a logical OR, but gives you the flexibility to move beyond a binary condition. I have tried to set up page navigation/filters but its complicated, so what you are suggesting here could be a great work around. I want to show the water level in my reactors so I used a card, the problem is since In the same page i have two filters, Reactor and pump for pump. Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. Another approach would be to set the title of the chart to give a message instructing the user to select a value first, Cool and clever approach, but the transparent card gets in the way of interacting with the underlying visual. how can I achieve this ?