Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
Saeed A
i have a line graph which needs to display past 2 months data and current month data
i have the formula as well but it is not showing any graph
https://drive.google.com/file/d/1lTcK5CQsdl3rteKc5GLimkEmjcjPDGR7/view?usp=sharing
Solved! Go to Solution.
@greeshma ,
The first step is to click on the "View details" link, says there is an error in comparing dax: you are trying to compare integer and text.
The selected slicer gets the month name and tries to compare it to the month number.
Hi @Anonymous ,
the DAX error is that [Selected Slicer] returns the MonthName and not the Month (No.)
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
@greeshma ,
The first step is to click on the "View details" link, says there is an error in comparing dax: you are trying to compare integer and text.
The selected slicer gets the month name and tries to compare it to the month number.
| User | Count |
|---|---|
| 49 | |
| 37 | |
| 33 | |
| 22 | |
| 18 |
| User | Count |
|---|---|
| 133 | |
| 99 | |
| 57 | |
| 38 | |
| 38 |