Month Abbreviation
Hi, in my data I have two fields YEAR and MONTH that I used to create a new column Date = DATE (Data[YEAR],Data[MONTH] ,1) and setting its data type as Date/time I obtain this: which I used to build different graphs., e.g. The problem is that I would use the abbreviated month to save space but I cannot find the way, I tried several approached but none of them worked. Could you help me?
Shape map in Power BI Desktop RS
Hello community, Last september, I created a report on PBI Desktop for Report Server which contained a shape map (with a TopoJSON file). But today, when I reopened it to do a modification, the component had disappeared from the visualizations pane. The visual is still present in the report, but it is not possible to add a new one (except by copy/paste the old visual). Is it normal that this component disappeared from the visualizations pane?Measure the effectiveness of your Power BI reports with BI Pixie by Gil Raviv
In today’s data-driven world, understanding how users interact with your Power BI reports is crucial for improving user adoption, enhancing report effectiveness, and measuring ROI. How can you evaluate the return on investment of your Power BI reports? In this session you will learn how you can achieve it with a new tool that offers a unique solution to this challenge by delivering deep analytics on user engagement and interactions, enabling organizations to measure active versus passive users, track user adoption, and identify inefficiencies in report usage. Join Gil Raviv in this session to learn about BI Pixie and learn how you can - 1) Track usage and engagement from the highest level of capacities to the lowest level of a single visual. 2) Provide insights into the effectiveness of mission-critical reports, helping you to continuously improve them. 3) Optimize your Power BI portfolio with actionable data on user adoption, attrition, and engagement patterns. 4) Transform the way organizations approach business intelligence by delivering rich, user-centered insights that help you drive better decisions, increase report usability, and justify future BI investments. Whether you are a BI leader, report developer, or a data-driven decision-maker, this session will demonstrate how BI Pixie can be a game-changer for your BI strategy. If you attend the live session, you will be entitled to a free 30-day PoC of BI Pixie Enterprise for 30 reports and Gil's live support. TENTATIVE AGENDA (subject to change, all times listed are in Pacific Time): 5:45pm Teams Meeting opens 6:00pm-7:05pm Welcome 6:05pm-6:05pm Feature Presentation 6:05pm-7:10pm Wrap-up REGISTRATION: This meet-up will be hosted on Microsoft Teams and will be recorded for those who cannot attend live. To access the Teams Meeting link, you must RSVP for the event. JOINING THE EVENT: Attendees can join the Teams Meeting starting at 5:45 pm PST on the day of the event. The link will be visible only if you RSVP beforehand. The event will begin at 6:00 pm PST. Please ensure you are on mute to minimize background noise and distractions. During the presentation, type your questions and comments into the chat area, which will be monitored by the event hosts. There will be a Q&A session at the end, where you can unmute your mic and share your video to ask questions.IF value exists on calendar date
Hi everyone, i need help creating a measure that evaluates whether a value in on table exists at a particular date within the calender table . I am working with Two tables, on main table that has a customer and a purchase date. The second table is just a table showing the daily calendar dates. the outcome wanted is to evaluate whether a purchase was made by a customer at a certain date on the daily calender. the tables are as shown below : RESULT If a customer has purchased something on the date equivalent to the calendar date, return true, else false. as shown below: If anyone could assist me with writing a measure that could produce this outcome that would be wonderful 🙂 all help and sugegestions are welcome: Thank you2º Encuentro presencial grupo de usuarios Power BI Albacete
Convocamos el segundo encuentro presencial del grupo de usuarios de Power BI de Albacete, por lo que si te apasiona esta tecnología y estás en la ciudad o alrededores, serás bienvenid@. Tendremos dos sesiones, la primera, Web scrapping. Caso de uso de extracción de datos públicos por Raúl Vinuesa Arjona, y la segunda El visual adecuado. Guía práctica y estrategias de data storytelling, con Paula García Esteban. Posteriormente tendremos un momento de networking para discutir sobre la comunidad local de Power BI y terminaremos con unas #powercañas. ¡No te lo pierdas! #somospowerbi #comunidad
Visualization Formatting Differences between Report Server and Desktop
Hello, I am adding data to an existing visualization in my organization, but it appears that there are formatting lines that separate the caregories in the Report Server view. I want to figure out how to view these lines on Desktop, and/or remove them entirely. These lines appear to be somewhat arbitrarily placed. In the screenshot below, in red, you can see that the second arrow shows that the line extends to the top of the visualization, while the third arrow shows that the line stops between the two headers. The purple arrow shows that the line in the third column was improperly placed, after the # column, instead of before it. The screenshot below shows Power BI Desktop, where these lines do not appear at all.Visualisation (Slicer and Button Slicer)
Hi everyone, I hope you all have a nice day. I want to ask (pictures attached), I gave an example of me using visualisation of "Button Slicer (Top)" and "Slicer (Bottom)" in the picture, I have a table where I have Reporting Date column then I make custom column for the quarters and months. The "Year" in the slicer is from Reporting Date hieararchy (Year), but the quarter and month in the slicer, they both are custom column that I made from the Reporting Date column (so they are not the hieararchy of "Reporting Date"). My questions (I don't mind if you answer with "Slicer" visualisation or "Button Slicer" visualisation): In Picture 1, If I select Q1 and it turns grey, how do the visualisation slicer for months turns black (for Jan, Feb, Mar) without me selecting the Quarter slicer? In Picture 2, If I select any month (for example: Aug) and it turns black, how do the visualisation slicer for quarter turns grey (Q2) without me selecting the Quarter slicer? In Picture 3, If I select Year "2025" and it turns black, how do the visualisation slicer for quarter and months also turns black without me selecting Quarter and Month slicer? Please kindly help me answer my questions. Thank you in advance. God bless. 😊🙏
