cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## Show blank " " on CARDS when nothing is selected on a Graph with Drill down.

I have a table of dates and number of instances per date. I set up a drill down. I would like to show the Year when drilling down. Currently the option that I can see is Min - Max. I am not familiar with DAX, but can follow instructions.

The first table shows the Years and the second is the drilled down. As you can see, it does not show which Year was selected. I would like the Year to show either on the Title or on a separate Card visual.

1 ACCEPTED SOLUTION
Super User

@New_Folder , You can create a measure

if(isfiltered(Date[Year]), selectedvalue(Date[Year]), "All Year")

You can use this measure in title or card

3 REPLIES 3
Community Champion

First, go into the x-axis in the formatting pane and make sure the Type is set to coninuous.

Expand the visual as

go into the x-axis in the formatting pane and turn off concatenate labels.

Optionally, you can add a dynamic title to the visual to help guide your users. Create a measure along the lines of:

``````Year Title =
VAR _MinYear =
CALCULATE ( MIN ( 'Calendar Table'[Year] ), ALL ( 'Calendar Table'[Year] ) )
VAR _MaxYear =
CALCULATE ( MAX ( 'Calendar Table'[Year] ), ALL ( 'Calendar Table'[Year] ) )
VAR _Sel =
CONCATENATEX ( VALUES ( 'Calendar Table'[Year] ), 'Calendar Table'[Year], ", " )
RETURN
IF (
ISFILTERED ( 'Calendar Table'[Year] ),
"Sales for " & _Sel,
"Sales from " & _MinYear & " to " & _MaxYear
)
``````

In the formatting pane, go into General -> Title and add the measure to the conditional formatting option,

Now you are ready to go. Just beware that the "Drilling" / Hierarchy ribbon can be confusing to users. (Here the title really helps)

1) "Go to next level of the hierarchy" displays aggregated data by month for all the years

2) "Expand all down one level in the hiearchy" still displays data for all the years, but by month and year:

3) By turning on the "drill-down" option, you can access a particular year data by clicking on a data point

Hope this helps

In doing so, you are also helping me. Thank you!

Proud to be a Super User!

Super User

@New_Folder , You can create a measure

if(isfiltered(Date[Year]), selectedvalue(Date[Year]), "All Year")

You can use this measure in title or card

Helper I

I might miss a detail here, should I replace something on the formula you provided? Im getting this error,

I think I got it working. How do I format to remove the thousands comma separator?

ugh, nevermind, found it.. thank you very much awesome internet people.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors