Forum Discussion

yfquirogah's avatar
yfquirogah
Icon for Helper I rankHelper I
5 years ago

Slicer not removing dates from visual

I'm having an issue with a couple visuals. I have a measure which counts the amount of "entries": Cant. Ingresos = COUNTROWS('Altas_2019-2020')+0 The 0 at the end I had to use it for the chart t...
Need Help
Show and Tell
parry2k's avatar
parry2k
Icon for Super User rankSuper User
5 years ago

yfquirogah do you have a separate table for a date that you are using on the x-axis? if not then you need to add a date dimension and use that on the x-axis and on the slicer. Link to how to add date dimension to your model.

 

 

 

Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

  • yfquirogah's avatar
    yfquirogah
    Icon for Helper I rankHelper I
    5 years ago

    I have a Calendar table, is connected to the entries table by the date. From the calendar table I'm using the year and month Hierarchy as the x-axis and the year field on the calendar table is the one I used on the slicer.