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. 😊🙏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 youShape 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?
create area chart with green and red colors to indicate profit and loss
I have created area chart that that shows profit and loss % over time. I would like to show the loss (negative part) in red color and the profit ( positive part) in geen color. i created 2 measures one for profit % and one for loss % positive p&l = var pl=[p&l %] var result= IF(pl>0 , pl,0) return result negative p&l = var pl=[p&l %] var result= IF(pl<0 , pl,0) return result when i added the measures in the chart it looked like: any idea on how to create the area chart with green/red colors instead of 1 color
How to use Video Pro by Cloudscope custom visual?
Hi all, I am trying to make use of "Video Pro by Cloudscope" custom visual. As of my learnings, there are two visuals by cloudscope that lets us embed video 1.Video Pro by Cloudscope - Certified (can't access external links[http:\, https:\].Need to embed video within dataset) 2.Video by Cloudscope- Uncertified ( can access external links [http:\, https:\] I am clear on how "Video by cloudscope" custom visual works. Can anyone help me in understanding the functionality of "Video Pro by Cloudscope". what is the difference between video and video pro? Also, any guidance on how to embed video within dataset . Here I am trying to use excel file for exploring purpose. Not sure on how to embed a video inside excel. I tried to embed using insert-> object method in excel but while importing excel source to Power BI, it gets displayed as null. Any solution to this asap would be much helpfull. Thanks in advance.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?
