If the user hasn't selected either a single product or a single store, the measure returns: “Select a single product and Ctrl + click to also select a single store.” For example, if you want the user to select a single product and a single store before they can drill through to the Market Analysis page, you can create a measure with the following logic: You can set the disabled state tooltip to be prescriptive on a case-by-case basis using a custom measure. If you've used conditional formatting to dynamically set the drillthrough destination, you may want the tooltip for the button state to be more informative, based on your end user’s selection. You can conditionally format the tooltip for the drillthrough button when it's enabled or disabled. Set formatting for tooltips conditionally When either no products are selected, or more than one product is selected, the button is disabled. When a single product is selected, the button text reads: Then, you select the measure you created for the button text: Once you've created this measure, you select the Conditional formatting option for the button text: Here's an example measure that outputs "See product details" if a single Product value is NOT selected otherwise, it outputs "See details for ": String_for_button = If(SELECTEDVALUE('Product', 0) = 0, "See product details", "See details for " & SELECTEDVALUE('Product')) To do this, you need to create a measure in Power BI Desktop that outputs the desired string based on the DAX function SELECTEDVALUE. You can use conditional formatting to change the button text based on the selected value of a field. Set formatting for button text conditionally Outline controls: color, transparency, weight, round edges Icon controls: shape, padding, alignment, line color, transparency, and weight You can customize the formatting options for the disabled state of drillthrough buttons.īutton text controls: text, color, padding, alignment, size, and font familyīutton fill controls: color, transparency, and new fill image (more on this in the next section) There's ambiguity about which data point from which visual to tie the drillthrough action to:Ĭustomize formatting for disabled buttons In this example, the button is disabled because two visuals both contain a single selection on Product. Since the drillthrough button isn't tied to a single visual, if your selection is ambiguous, then the button is disabled. For example, using Ctrl + click and cross-filtering, you can pass multiple filters on Store to the drillthrough page because your selections cross-filter the visual that contains Product, the drillthrough field:Īfter you select the drillthrough button, you see filters on both Store and Product being passed through to the destination page: The button works like the regular drillthrough: You can pass filters on additional fields by cross-filtering the visuals that contain the drillthrough field. You can also apply conditional formatting to tooltips. However, if you'd like to provide custom tooltips, you can always input a static string. "Click to drill through to Market Basket Analysis. "Īnd here's an example of the autogenerated tooltip when the button is enabled: "To drill through to Market Basket Analysis, select a single data point from Product. Here's an example of the autogenerated tooltip when the button is disabled: Those tooltips are based on the destination and drillthrough field(s). If you leave the tooltips boxes blank, Power BI automatically generates tooltips. Then, you need to create a button with Drill through as the action type and select the drillthrough page as the Destination.īecause the drillthrough button has two states, enabled vs. To set up a drillthrough button, you first need to set up a valid drillthrough page within your report. As you can see from the visual on the left, the drillthrough page is now filtered for Word. When you select the See details button, you drill through to the Market Basket Analysis page.
![no quick analysis button no quick analysis button](https://www.quickintelligence.co.uk/wp-content/uploads/2016/10/Gauges-500x383.png)
![no quick analysis button no quick analysis button](https://canadanewsmedia.ca/wp-content/uploads/2020/12/robert-griffin-bud-dupree-1024x576.jpg)
In this example, after you select the Word bar in the chart, the See details button is enabled. For example, you can show different text on a button if certain conditions are met. You can conditionally determine much of how the button looks and acts.
![no quick analysis button no quick analysis button](https://howtoexcelatexcel.com/wp-content/uploads/2020/09/Excel-Quick-Analysis-Add-In.png)
The button can increase the discoverability of important drillthrough scenarios in your reports. If you want the drillthrough action to be more obvious, you can create a drillthrough button instead. One way to drill through in a report is to right-click in a visual. You can create a drillthrough button in Power BI, a button that drills through to a page with details that are filtered to a specific context. APPLIES TO: ✔️ Power BI Desktop ✔️ Power BI service