Forum Discussion
Dynamically Change Dates x-axis based on a Slicier Selection
JSIQUEI-YYC-ENB there are couple of possible issues, most probably it is data modelling (and dax) issue:
1) could you send screenshot of data model, to see where data comes from and which relationship is used
2) please share DAX calculations for measures that are used on chart (i suppose here is the issue)
3) try deselecting option "show items with no data"
Cheers,
Nemanja Andic
nandic Thank you very much for your prompt reply and here allow me to share some of it.
I suggest you try to format the x-axis dates to have a hierarchical structure.
Make sure your slicer uses the date column associated with the table.
Here is the result.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
JSIQUEI-YYC-ENB there are couple of possible issues, most probably it is data modelling (and dax) issue:
1) could you send screenshot of data model, to see where data comes from and which relationship is used
2) please share DAX calculations for measures that are used on chart (i suppose here is the issue)
3) try deselecting option "show items with no data"
Cheers,
Nemanja Andic
Hi nandic , thanks for you suggestion. I reviewed the meassure that I used on the chart, and now it's working porperly. Many thanks!