topic Re: Create a dax formula to show selected quarter after removing all filters from date table in DAX Commands and Tips

Create a dax formula to show selected quarter after removing all filters from date table

Anonymous — Thu, 03 Mar 2022 18:03:34 GMT

Hi All,

i am new to powerbi. i am strugling to build a dax expression that will show Selected quarter value . but before that i want to clear all filers applied on date table. could you please help me. thanks.

Arnab

Re: Create a dax formula to show selected quarter after removing all filters from date table

Samarth_18 — Thu, 03 Mar 2022 18:08:06 GMT

Hi Anonymous ,

Could you please share the sample data in text format with the expected output.

Thanks,

Samarth

Re: Create a dax formula to show selected quarter after removing all filters from date table

Anonymous — Thu, 03 Mar 2022 19:34:28 GMT

Hi Samarth_18 , please take a look at these pictures. i took slicer for Quarter (field taken from Dim_calendar) and and line chart(both sales & quarter fields taken from fact_sales table). here based on a selected quarter year from slicer i will get sales for last 3 quarters. Now i created a tooltip that will show quarter year when i hover on the line chart. but i can only see the quarter year on tooltip which is selected on the slicer, other quarter years are showing blank .

is there any way to create a dax expression that will remove any slicer selection , allow me to see all quarter year when i hover on the chart?

Re: Create a dax formula to show selected quarter after removing all filters from date table

Whitewater100 — Thu, 03 Mar 2022 20:12:55 GMT

Hi:

All your date fields should come from your Calendar Table, even the sales quarter should just be quarter. The Calendar table should be marked as Date Table too and have one to many relationship with your fact table. I'm not sure what the rest of your question is, can you rephrase it?

Re: Create a dax formula to show selected quarter after removing all filters from date table

Anonymous — Thu, 03 Mar 2022 20:29:46 GMT

Hi All, thanks for helping me to crack this logic. i might not be able to clarify my challenge. Anyway i tried this logic

TT Quarter = CALCULATE( SELECTEDVALUE(Fact_Energy[YearQuarter]),CROSSFILTER ( 'Date'[Date], Fact_Energy[Full Date], NONE )) and It Worked😀. basically i diasbled the relationship bitween fact and dim table.