top of page
flow analysis
designed by Jihwan
Unlock the Power of Data with Dynamic Insights: Dive deep into comprehensive data flow analysis with Microsoft Power BI and Fabric. Experience the magic firsthand by requesting a personalized demonstration of my analysis reports, or explore the "powerbi works" page & "blog" pages for inspiration and generate your own unique insights. Let's embark on this data-driven journey together!
Search

Line-by-line conditional formatting in a Matrix visualization in Power BI
In this writing, I want to share how I try to conditionally format each line (not by all numbers resulted by the measure) in a matrix...
Jihwan Kim
Jan 9, 20232 min read
196 views
0 comments
![The situation that I add a [Sales] column by writing [Qty] X [Unit price] in Power Query Editor](https://static.wixstatic.com/media/64d1a1_91d3297fd40745f281dd7fbc91494b8e~mv2.png/v1/fill/w_454,h_341,fp_0.50_0.50,q_95,enc_auto/64d1a1_91d3297fd40745f281dd7fbc91494b8e~mv2.webp)
The situation that I add a [Sales] column by writing [Qty] X [Unit price] in Power Query Editor
In this writing, I want to share when I decide to add a column in Power Query Editor, instead of writing a DAX measure in the Power BI...
Jihwan Kim
Jan 1, 20233 min read
195 views
0 comments

When do I use INDEX DAX function in Power BI?
In this writing, I want to share when I try using INDEX DAX function in Power BI. Recently (December 2022), there were three DAX...
Jihwan Kim
Dec 19, 20223 min read
536 views
0 comments

WINDOW DAX function in Power BI
In this writing, I want to share when may be the case I want to use the WINDOW DAX function in Power BI. In December 2022 Power BI...
Jihwan Kim
Dec 16, 20222 min read
793 views
0 comments

The problem that I face when connecting Dynamics 365 to Power BI
In this writing, I want to share my current problem, and ask a question about how to solve this problem. I have a simple solution to this...
Jihwan Kim
Dec 12, 20223 min read
124 views
0 comments

What I do when I configure direct query mode and aggregations tables in Power BI
In this short writing, I want to share what I do and check when configuring aggregations tables with direct query mode datamodel in Power...
Jihwan Kim
Dec 2, 20222 min read
229 views
0 comments

What I do as step one in DAX Studio to enhance DAX Measures Performance
In this writing, I want to share how I utilize DAX Studio to check & fix measures and enhance performance. This conveys what I do as a...
Jihwan Kim
Nov 21, 20223 min read
975 views
1 comment

Relationships between Field Parameters in Power BI. Don't let Field Parameters tables stand alone.
In this writing, I want to share how I use Field Parameter tables in my Power BI reports. Field Parameters feature came out to the world...
Jihwan Kim
Nov 14, 20223 min read
1,066 views
1 comment

Getting a recursive type column in Power Query Editor in Power BI
In this writing, I want to share how I try to solve questions that ask about getting recursive-type results in Power BI. I sometimes face...
Jihwan Kim
Nov 11, 20223 min read
222 views
0 comments

LASTNONBLANK & LASTNONBLANKVALUE DAX function in Power BI
In this writing, I want to share how I use LASTNONBLANK and LASTNONBLANKVALUE DAX functions, or how I do not use those to get the same &...
Jihwan Kim
Nov 7, 20224 min read
143 views
0 comments

TOPN DAX function with Pie chart in Power BI
In this writing, I want to share how I use pie chart in my Power BI report, even if some other Power BI authors do not prefer to use the...
Jihwan Kim
Oct 31, 20222 min read
27 views
0 comments

Incremental refresh configuration in Power BI
In this writing, I want to share what I consider when configuring incremental refresh in Power BI. Most of cases, I failed or got doubt...
Jihwan Kim
Oct 25, 20223 min read
192 views
0 comments

Two roles for one user - RLS (Row Level Security) in Power BI
In the previous blog post, I explained how to implement RLS and OLS (Object Level Security) at the same time for one user in one dataset...
Jihwan Kim
Oct 20, 20222 min read
195 views
0 comments

When can I use OFFSET DAX function in Power BI
In this writing, I like to share what I have learned about OFFSET DAX function, that recently came out to the world, but not yet...
Jihwan Kim
Oct 14, 20222 min read
500 views
0 comments

When to build a dashboard in Power BI service?
In this writing, I like to share when I need to build a dashboard in Power BI service, instead of just sharing reports. Situation In one...
Jihwan Kim
Oct 12, 20222 min read
24 views
0 comments

Virtual relationship by utilizing DAX, in Power BI
In this blog post, I want to share how I create a virtual relationship by using DAX formula when no physical relationships were found....
Jihwan Kim
Oct 5, 20223 min read
275 views
0 comments

When I fail to convince people about getting value from Power BI report, then I do this!
In this writing, I want to share what I usually do when I fail to get attention from people about having great insights from Power BI...
Jihwan Kim
Sep 30, 20222 min read
44 views
0 comments

Configuring & writing Format String Expression in Tabular Editor, in Power BI
In this writing, I want to share how I use Tabular editor in Power BI to change format of a measure that I use in a visualization. How to...
Jihwan Kim
Sep 27, 20222 min read
340 views
0 comments

Implement both RLS and OLS together in Power BI
In this writing, I want to share how I implemented both RLS and OLS together in my Power BI report. Most of my Power BI reports, I...
Jihwan Kim
Sep 23, 20223 min read
1,565 views
0 comments

ADDCOLUMNS + SUMMARIZE VS. SUMMARIZE and Calculated Column VS. Calculated Table in Power BI
In this blog post, I want to share what I have incorrectly understood in Power BI. I think there are more than 100 things I still do not...
Jihwan Kim
Sep 19, 20223 min read
197 views
0 comments
bottom of page