Forum Discussion

sunjin122's avatar
sunjin122
Helper I
9 years ago
Solved

Filter not working

Hi there,   I put a Year hierarchy slicer on my report. However, when I select any specific day, all the other charts stop working. As the pic shown below. I've used the same slicer on other report...
Need Help
  • sunjin122's avatar
    sunjin122
    9 years ago

    The data I used for the report is live data which was laoded by Directquery. The original Date column is Text format, like "20140503", and The downside of Power BI is that I cannot change the data type of live data in Edit Query.  Then I learned that I can change the data type in the Modeling section. As the screenshot  shown below. However, this leads to the failure of slicer. I had to change the data format back to Text and use Dax function sunch as "Left", "Right" to extract Year, Month and Day. In this way, the slicer works well. Hope Power BI can fix this defect someday. 

     

     

KGrice's avatar
KGrice
Memorable Member
9 years ago

What do you get when you click the link for See details on the visualizations? Do they each say the same thing?

sunjin122's avatar
sunjin122
Helper I
9 years ago

KGriceThanks for your response, I've firgured it out. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi sunjin122,

    You can share detailed solution in this forum, this way, other community members could benefit from your solution if they encounter same issues.

    Thanks,
    Lydia Zhang