Questions about Power BI custom visuals: their development, capabilities and usage. Power BI is a self-service analytics tool. Custom visuals are visualization plugins for Power BI, written in TypeScript or JavaScript using the Custom Visuals SDK.
Questions tagged [powerbi-custom-visuals]
389 questions
0
votes
1 answer
how to give color to a slicer tile when selecting in PowerBI?
I like to shed blue when selecting Options in my slicer tile in PowerBi report, How can I do that?
Please see below picture for sample
HaiY
- 145
- 1
- 5
- 15
0
votes
1 answer
Power BI X axis issue with days and hours
I'm new in Power BI and I would like to a create a line chart, with Selected Days and Hours on X axis, and the sum of values on Y axis in a selected Year. For example:
As you can see I could do it, but with a scrollbar. I can't change the X axis…
Mark
- 3
- 2
0
votes
1 answer
Conditional formatting Grand total in a matrix- Power bi
I am looking at changing color for the total field in a matrix table, the total field is a Column subtotal done in power bi formatting.
I want to be able to change the color depending on the line results.
so basically if the first total is less…
Rafa Jammali
- 21
- 6
0
votes
0 answers
How to Calculate Variance with PowerBI DAX Waterfall Chart
I've sifted through threads and videos trying examples, but I still seem to be stuck. Please help? DAX newbie here.
I have a data set with yearly sales with granularity by geography, device type, and another column with ~6 different technical…
hakunamatata
- 11
- 4
0
votes
1 answer
PowerBI issue with visuals, asTimeline and a Table
I have asTimeline visual and below a Table. The idea is to display in the Table a Link to the specified record in another system. The problem is that I would like to show this Table only when there is exactly 1 record selected in asTimeline.…
n0e
- 309
- 3
- 12
0
votes
1 answer
How to calculate the Yeserday, last 7 days, this week till day, this month till day user logged count in power bi?
I'm trying to calculate the user logged in count on system.
In my table i have
Id, TRANSDATE now i want to calculate the measure on four categories
which are yesterday, last 7 days, this week till day, this month till day count.
Yesterday =…
KARTHIKEYAN.A
- 18,210
- 6
- 124
- 133
0
votes
1 answer
How to find difference between two level between the columns in DAX
I am trying to find the difference between Quarters in two different years in Power BI DAX.
Below is the result i am expecting.
I tried this calculation but dint get the expected result. Please help
Diff =
CALCULATE (
SUM(Sample_Data[# Phone…
Karthik
- 41
- 4
0
votes
1 answer
Graphic to replay state over time
I have a blueprint of a house and would like to create a graphic that will show when each door was opened over the course of a single day. I do not want to aggregate the data in any way and would like to be able to replay the entire day --using a…
JMo
- 101
- 5
0
votes
1 answer
Power BI: modify slicer input to filter different values
Please help me if you know how to solve this:
I have a column which I imported using a direct query that has date and time values in a single column with each field looking like this:
2018-07-10 4:01:36 PM
I want to use these values to let the user…
0
votes
1 answer
how to pass today date as dynamic input date in power bi advanced editor?
I'm trying to pass the day value as of today date in the advanced query editor
let
Source = GoogleBigQuery.Database(null),
#"apple-5a221" = Source{[Name="apple-5a221"]}[Data],
analytics_187358390_Schema =…
KARTHIKEYAN.A
- 18,210
- 6
- 124
- 133
0
votes
1 answer
How to produce result based on date with multiple conditions on power bi?
I'm trying to create validation based on date and some filters
my input table is
Status Type Date PolicyNo
PS T607 01-01-2020 1002
PS T608 01-01-2020 1002
CF T646 01-01-2020 1002
PS T607 04-01-2020 …
KARTHIKEYAN.A
- 18,210
- 6
- 124
- 133
0
votes
1 answer
how to calculate total sum and maximum used screen count in power bi?
How to calculate the total count with respect to enabled date and maximum used screen count with its name
My Input table
Date Name Id Count Screen Enabled Date
03-01-2020 Karthikeyan 1 4 Login 03-01-2020
03-01-2020 …
KARTHIKEYAN.A
- 18,210
- 6
- 124
- 133
0
votes
1 answer
How to create summary tables based on EnabledDate, EnabledDate + 1, EnabledDate + 2, EnabledDate + 7 with date filter option on power bi?
I'm trying to create a summary tables base on 4 conditions on the date range
Input table
Date Set in text form
Date Name Id Count Screen Enabled Date
03-01-2020 Karthikeyan 1 4 Login 03-01-2020
03-01-2020 Karthikeyan 1 3 …
KARTHIKEYAN.A
- 18,210
- 6
- 124
- 133
0
votes
2 answers
How to summarize column with condition on power bi?
I'm trying to create table summary table with following conditions
From the Original table to summary table we have to create using the following conditions
1) select distinct ids
2) select screen name base on highest count group by id and today…
KARTHIKEYAN.A
- 18,210
- 6
- 124
- 133
0
votes
1 answer
How to copy highest value name as new column value in power bi?
I'm trying to create a new column which is filled by the highest value name and condition is today date and if suppose two values are the same then we have to pick the first one value name.
My table is
My Expected table is
Condition is
select…
KARTHIKEYAN.A
- 18,210
- 6
- 124
- 133