I have one query, I have made the last 13 months and date range slicers. Now I want to default is 13 month's, that is working fine. When I selected last 5 months in the date range, and I again back to last 13 months (we don't want to reset the date range filter). That time last 13 months is not working, give me any solution or make a one video on this. If you possible
Hi Ajay I have small questions Suppose we have 2 tables A and B A table contain 10 emp Id and B table contain emp Id and grade . And B table contain only 5 emp id and grade.you can say only 5 records available in table B. So want to show grade on X axis and and no of emp Id from A table on Y axis So out of 10 emp I'd 5 empid show respective grade And remaining 5 it is showing blank But I want to replace that blank with some text. Is it possible?
Hi Lucky! First of all, please accept my apologies for the late reply. I have so much to do! For your question, yes you can do this. For this, you have to create a DAX measure where you will use DISTINCTCOUNT DAX function along with ISBLANK () DAX Function. ISBLANK() would replace NULL values with zero or anything you would like to add there.
I have one query,
I have made the last 13 months and date range slicers. Now I want to default is 13 month's, that is working fine. When I selected last 5 months in the date range, and I again back to last 13 months (we don't want to reset the date range filter). That time last 13 months is not working, give me any solution or make a one video on this. If you possible
The default can be only one value! As far as I have experience, it cannot change everytime you make the selection
Hi Ajay I have small questions
Suppose we have 2 tables A and B
A table contain 10 emp Id
and B table contain
emp Id and grade .
And B table contain only 5 emp id and grade.you can say only 5 records available in table B.
So want to show grade on X axis and and no of emp Id from A table on Y axis
So out of 10 emp I'd
5 empid show respective grade
And remaining 5 it is showing blank
But I want to replace that blank with some text.
Is it possible?
Hi Lucky! First of all, please accept my apologies for the late reply. I have so much to do!
For your question, yes you can do this. For this, you have to create a DAX measure where you will use DISTINCTCOUNT DAX function along with ISBLANK () DAX Function. ISBLANK() would replace NULL values with zero or anything you would like to add there.
Spelling of measure is wrong in the video thumbnail.
Thank you, Sir! It's been corrected.